If you are on a shared hosting box, you can ask one of the admins to put this proc into your database for you with an 'EXECUTE AS' clause that...

I've recreated the problem. It returns no results if you do not have the 'VIEW SERVER STATE' permission. Looked it up in the sys.dm_db_missing_index_* entries in BOL. ...

I'll put up a fix. It is working on my system with the missing 'sys.' ,which is probably why I didn't catch it. It is inconsistent with the...

Oh I see. You are using a case senstive sort order / collation at the server level.

I have no idea why it is blowing up. It is compiling for me, even with compatibility mode set to 80 (its not a freshly upgraded database though).

There is a remark in BOL saying 'Aggregates on floating-point numbers might return slightly different results.' Where in the question does it say that the sales column is a floating...

It don't, but you wouldn't want to see this coding practice (not dropping temp tables) in real applications, so one would want to set an example for that for noobs...

You forgot to put drops for you temp tables (#data, #category) at the end of the code block.

I think whether you get these commitments and stuff depend on whether you live in a 'right to work state'. According to Ginger, Arizona is a right to work...

I get 85K/yr as a database developer and i've expensed one conference (SQLConnections Las Vegas in Nov; $3000) and a 2-year subscription to SQL Server Magazine Print+CD ($150). So...

Know what the database request timeout is, and then look for things coming from the offending application with durations exceeding this. The default timeout for ADO is 30 seconds....

Oh cool. I just tested that myself. I wouldn't think Microsoft would be inconsistent like that. A 25% sampling became 100% after rebuilding an index. I...

DBCC DBREINDEX and ALTER INDEX REBUILD rebuilds statistics with the RESAMPLE option - it uses the sample percentage that was used on the last manual or auto update. It also...

If you are in 2005, you can cast it to nVarChar(max) before running it through the replace. Otherwise you'll have to break it up into 4000 char pieces, replace...

As far as I know, SQL Server indexes cannot cross table boundaries. Each table has to have their own stand-alone indexes on their PKs and FKs. Usually the...