We have 2 x SQL Server 2005 and database mirroring is enabled and
working.
Server A = Principal
Server B = Mirror

I was wondering if it was worth it to put the system log (ldf) files on a
different physical drive than the data files.
I was going to move the master, model, msdb and tempdb log files to a
different drive.

SQL Server 2005 Enterpise SP2
Windows 2003 Server Enterprise SP2
Snapdrive software maps LUNs from Netapp
This server has 5 drives that show up local to the server. They are SAN

Will there be a SP3 to SQL2005, now that SQL2008 is in RTM.
We got a lot of SP2 SQL2005 server, and dont know if we shall wait for SP3
if it come... or to upgrade with UP9 patch to SQL2005

I recently put in a change to tempdb splitting it into 8 data files,
one per each processor over our SAN as well as putting in the -T1118
startup parameter for page allocation within TempDB on our main
datawarehouse server.  Since then all runs well except 1 job.  This

we have SQL server 2000 and had more than 100 Device CAL's (SQL 2000 CALS
and SQL 2003 CAL's). We want to add few more lincense and vendor says the
current SQL CAL availble is SQL Server CAL 2008 and can not be used with SQL
server 2000.

Someone has set the compress drive flag on a SQL 2005 Windows 2003 disk
drive.  Our vendor thinks this may be the reason users are experiencing
performance issues with the application.
What can we expect if we remove the flag?  

This URL which lists the SQLServer build numbers is incomplete. Does anyone
know a more up-to-date one?
http://blogs.msdn.com/blogfiles/ukdynsupport/WindowsLiveWriter/Allyouneedtoknowa
boutSQLServerbuildnumbe_EE82/image_2.png
TIA,

I got a new computer at work.  I installed client tools on it.  When ever I
open a table in SSMS, my scroll/screen refresh rate in SSMS is very
slow...almost painfully slow.  On my old computer it is very fast...almost
instantaneous.

We are in the process of purchasing SQL Server 2008 in order to upgrade
installations of SQL Server 2000. One of our applications uses a number of
stored procedures to operate.
What kind of issues are involved in doing such a conversion? We had

We are seeing an 8152 truncation message on one server that is not showing
on another server. This message should be showing up as we are trying to
squeeze 9 characters into a 7 character column. As this showed up in
Acceptance testing when it works in Development I was wondering ...

Has anyone come across this error when trying to restore a litespeed backup?
SLS Error: XML returned from Engine was invalid. :
Error Msg: (0):  '2008-08-31 21:00:12' restore failed for "dbname".
I'm on ls version 4.8.4.00086 and the backups where done in 4.6.0.00293 (my

update TABLE set COLUMN_A = 0 FROM TABLE where EXISTS (select TOP 1 * from
TABLE where ID = 1 order by row desc)
My TABLE includes the following data:
ROW   ID  COLUMN_A

MS08-052 has an SQL2005 component that is fixed in CU9 (build 3282). I have
not seen very much about the SQL part of this security bulletin but it looks
like it is Reporting Services that is affected.
We have Reporting Services installed and are running it under a low

I found there is a sql 2000 server with OS 2000 has multiple databases with
identical structure in one instance. Each database is used by one client. Is
this good idea? They are sharing one tempdb and tempdb is used very heavily.
I was told this server is 2 Cpus quad core, does ...