Server Configuration

Reference architecture for mobile data acquisition?
Hello, not sure if this is an appropriate group for this question, but SQL server is part of that ... Basically I'm looking for some kind of reference architecture for a project which is basically about mobile data acquisition. On an embedded device running WinCE and SQL Compact Edition 3.5, measurement dat... 27 Apr 2010 08:47

VM Disk Configuration for SQL Server (2005/2008/2008 R2).
I read in one of the blogs that Microsoft recommends settingup "Pass Through Disks" as compared to "Fixed" or "Dynamic" disk in VMs. Is this the official policy and can I get any white paper, weblink on that? I was talking to the Storage Engineer at my workplace and he remarked that Pass Through Disks would r... 27 Apr 2010 14:30

Trace Flag Definitions
What do trace flags -t3601 / t3603 do and are there performance hits from using them? ... 27 Apr 2010 08:47

Error on log file growth.
I am getting this error when we try to grow a logfile. FCB::ZeroFile(), GetOverLappedResult(): Operating system error 27(The drive cannot find the sector requested.) encountered. SQL 2008 Enterprise 64 bit SP1 Windows 2008 R2 64 bit fully patched. Latest firmware and drivers for HP EVA 6400 San, 4 8GB QL... 26 Apr 2010 14:57

Maintenance Plan - Backup
Hi, I have configured two maintenance plan to make backup of all databases. one nightly to backup from monday to saturday and one weekly to backup on sunday. the filename of all backup has generated automatically from the system and it is: <db-name>_backup_<date>_<random numbers>.bak. is it possible add in... 27 Apr 2010 08:47

Difference between SQL 2008 Server Express and SQL 2008 R2 Express
I am confused... A year or so ago I installed SQL 2008 server Express - the free version. I had developed an application that connects to the server using ADO. Every thing works fine. I need to change my XP box to a vista one and needed to reinstall SQL 2008 Express (the free version) however I ran into a versi... 26 Apr 2010 13:48

Big transaction log file
I moved a SQL 2000 database to SQL 2005, changed some tables and re-indexed them. The Recovery Model is Simple. Data is about 13 gig in size, and the log file is about 16 gig in size. When I do "DBCC SQLPERF(LOGSPACE)" it shows that very little of the transaction log file is being used: Database Name Log ... 27 Apr 2010 08:47

SQL Server 2005 sp3 Query Execution Issue
I am running this really complicated olap query on my workstation (xp 64 bit) which takes roughly 8 minutes to complete. During execution the cpu utilization is pushing 100% but oscilates. When I run the same query against a db containing the same data on windows server 2003 on a machine which is much more po... 23 Apr 2010 18:12

SQL Server 2005 and 2008
All of my databases are currently in SQL Server 2005. Thus, I have SQL Server 2005 Management Studio installed on my machine to connect to my SQL Server 2005 instances. We now have a SQL Server 2008 instance setup and I want to know if I connect to a SQL Server 2008 database via my current Management Studio? Sh... 23 Apr 2010 01:23

Best Practice - Converting ntext to nvarchar(max)
What is the best practice for converting ntext columns to nvarchar(max) in a existing SQL 2005 or 2008 database? Is ALTER enough? Or are there other considerations. I've read in one post that the converted columns should be set to itself to force a reallocation of the data. UPDATE Table1 SET TextCol1=TextC... 22 Apr 2010 18:42