Congrats on the 400k, and thanks very much.

Or for two columns and one row. Untested, but should work.

SELECT Status, SUM(CASE Copies WHEN 0 THEN 1 ELSE 0 END) AS CountCopies0, SUM(CASE Copies WHEN 1 THEN 1 ELSE 0...

Interesting stories

I was born in Burmingham in England, but moved to South Africa with my parents when I was very young. Other than four years at university in Grahamstown (1000km...

If the clustered index is on the GUID, you can get an improvement by rebuilding the clustered index, as it's probably badly fragmented. Once the index is rebuild you should...

Answered here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=338509

Please don't cross-post, we do see all new posts to all forums.

Thanks

Non-clustered indexes on a heap table point to the data using the RID, because there's no alternative.  So, why do others use the clustered index instead of the more direct...

A non clustered index only has in it the values of the columns contained within the index. It dosn't have the rest of the row. If ta query is done...

Check to see if it is SQL that's taking the CPU. There shouldn't be anything else running on a SQL Server, but is worth checking. Use task manager for this.

Rebuild...

First things, since you shrank the database. Grow it back to a reasonable size and rebuild all the indexes. Shrinking a database shuffles data pages around, fragmenting indexes very very...

Create a 2 column unique index. While there can only be one pimary key on a table, there can be multiple indexes.

CREATE UNIQUE INDEX idx_MyTable_EmailPassword

ON MyTable (email, Password)

Trigger will work,...

Be aware that your solution won't handle cases where multiple rows are inserted in a single batch. Your trigger will only get one of the inserted rows.

If means that on your production server the query is reading more data pages, either from memory or disk, than on the dev server.

There shouldn't be much disk activity on...

This is from memory, cause I don't have a SQL 2000 server here.

In enterprise manager, expand out the server. Select management (I think) expand out and you'll see entries for...

Don't shrink a DB after a reindex. You're just undoing all the work that reindex did.

If you absolutely have to, make sure that you use the TRUNCATEONLY clause, to just...

Check your disks. Sounds like you may have IO throughput problems

I had latch waits on one of my databases some months back. We traced it down to very slow SAN...