PW:

That is a good point. I guess I can make my PK index as a clustered index at 100% fill factor and then drop the clustered index. I figured, since...

In this case, I am NOT using a clustered index, here is how I justify this:

I add a non-clustered index on the primary key columns (col1, col2 and col3 for...

Thanks for your participation and sharing your thoughts on this topic. Let me add some context to my original question with an example. Consider this scenario: A very large table...

Thank you, you have set me in the right direction.

Is there "ever" a way to use aggregates in the exists clasue, like this?

(I do not think so, but...

Copy the registry contents from the old pc to the new pc from this location:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

restore to the same location using any registry copy. I use...

We used to several SQL servers and SQL clusters and at one time used to have SQL mail on each server. We were not even using Exchange, but using Novell...

Another solution that I found on this forum:

ALTER FUNCTION udf_concat (@i INT) RETURNS VARCHAR(100)

AS

BEGIN

 DECLARE @concat VARCHAR(100)

 SELECT @concat = ISNULL (@concat, '') + col +' '

 FROM test WHERE col1 =...

I had similar errors, but we were using SAN not NAS though. When contacted MS they provided a hot fix Q838647, which  was for some SANs connected to Cisco switches....

Collect the perfmon stats for disk queue lengths. Usually this is an indication of disk system saturation. Are any backups running at the time of the error?

Max degree of parallelism restricts # of processors per "a" query. So , if this value is set to 4, processors 0-3 may be used for query 1, then processors...

Thanks to Journeyman and Rockmoose, these are good solutions.

 What kind of SAN are you using? We had a problem with one of our DB servers, where it would intermittantly give up while reindexing some large tables, the same...

I have been a SQL DBA and Programmer for around 10 years. I have come across several books, most of which are in essence a rehash of what is in...

Did you run DBCC updateusage OR sp_spaceused with True. The table free space (in extents only) is reclaimed as they become free  . How ever, sp_spaceused may not reflect this,...

Check the table fragmentation with DBCC showcontig. Based on the indexes and the order of inserts, over a period of time the table could get severely fragmented slowing down inserts....