can you please give me an idea about the advantages/disadvantages between
using numeric identity versus uniquidentifier in sql 2005 and which is a
better choice generally?
Is there an article on MSDN in a table format that lists the differences

        We have a production database which is in SQL Server 2005.
All the stored procedures and Views created in 2005 ( 90 )
compatibility. Some Stored Procedures and Views started failing one
day.  We found that the database has compatibility level is on 80, but

I'm using the SQL Server 2005 tuning wizard and its come back with a few
suggestions.
If I implement the suggestions it estimates a -1328% improvement. Now
does this mean things will be -1328% "better" or -1328% worse

i know how to check what version of service pack i have installed on
sql server 2000...but does anyone know how to find out the date it was
installed on.
i am having probs with sql server agent and can see the date the probs

what is faster - LEFT JOIN or subselect
example
SELECT T.TITLE,S.ID FROM TITLES T LEFT JOIN SINDEXES S ON T.ID=S.TITLE_ID
or

I have (had) a development machine with sql svr 2k running, it
was only used to test the software we developed.
Well, the sql server machine died, it still boots and the drives
are accessabe. but sql server won't start (as won't many other

Hi all hope this is in the right forum.
Ive got a SQL database which accumulates about 4 million records each year.
This amount causes my PC to slow down when searching, and my hard drive is
getting fuller.

One section of my database allows users to browse for a picture, then
it stores the network path. the problem is that they are using their
server mapping to browse, which stores the path as:
U:\Spindle\Spindle_DataBase\Pictures\Linked Pictures

Is it possible to have SQL 2000 standard and SQL 2005 enterprise running on
the same machine?

What does autoclose do ?
And why Starting up database message is repeated when autoclose is
true?

I am having one stored procedure which is returing parameter having
text data type.
This paramter has to take value from table which have column with
datatype as text.

If the SQL Server uses all 8 GIG of RAM in the server and something goes
wrong in the OS, can the OS retrieve the RAM it needs if it is using default
virtual memory management?

I have a database which constantly saying it i starting up!!!!
2007-02-28 12:32:22.96 spid63    Starting up database 'QA_Test'.
2007-02-28 12:32:22.98 spid63    Starting up database 'QA_Test'.
2007-02-28 12:32:23.01 spid63    Starting up database 'QA_Test'.

I have a setup where in following scenario i get DCOM error
1. Install a 32 bit NT service on x64
2. Install SQL 2005 Server
3. Upgrade the 32bit NT service using msi package.

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer