I was very curious about inertia as a kid.  The old SF books by E.E. “Doc” Smith were a fun read.  I believe Feynman calculated the inertia of a...

I think the point is that you can't use a variable or expression to specify the column.  You also can't use a variable to specify syntax or table names.  You...

An order by expression can be a non-negative integer to represent an expression in the select list; however, I expect that an expression that evaluates to an integer is just an integer, not...

Is this related to notification services?  There is also "set statistics time on" and "set statistics io on" which can be handy. 

Sorry, missed that. 

Are you really sure that space is not a problem?  The maintenance plan can take a lot of space when doing disk backups and reindexing - it's not smart about...

Did the index maintenance get overlooked?  Have you checked for index fragmentation? 

I've created a job that logs the stats every 10 minutes and a report that lists the delta for each 10 minute duration.  Here is sample output...

In my case, I see CXPACKET waits while rebuilding indexes.  The other CXPACKET waits could well be due to design and code.  However, a setting change or hardware update is a lot...

Why wouldn't David's version work?  Nulls?  Duplicates? 

SELECT Country_Name

FROM tblCountry

WHERE NOT Country_Id IS NULL

ORDER BY

    CASE Country_Id WHEN 26 THEN 1 ELSE 2 END,

    Country_Name

SELECT...

Hi Colin.  I was looking at the CXPACKETS originally.  I noticed some very large values after re-indexing some dbs.  I was trying to determine if hyper threading might be a problem...

I found some related links.  This one describes similar results for the OLEDB counter. 

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8429&whichpage=1

This one has a bit of explaination of OLEDB, but not why the values appear...

It does rollover.  It appears that an unsigned 4 byte integer is used for each counter.  I've looked at the values of all counters on several machines.  None are over 4.29E9.   This...

Magarity, I'm curious.  Can you tell us the actual performance improvement? 

While I'm at it, here are the other wait types.  I'm tempted to just ignore the OLEDB counter and remove it from "***Total***", but I am worried that something might...