Hmmm. Wierd....

Can you run the following and post the output please

DBCC SHOWCONTIG('<table name>')

Is it possible to change the reserved size?

Not directly. Afaik, it's a measure of how many pages/extents are allocated to the table. Not something you can change manually.

Is there a...

With a set-based insert, the entire insert will succeed, or will fail. It's not possible to insert the rows that are OK and ditch the others.

If this is a common...

Have you tried rebuilding the indexes on that table since the delete? (specifically the clustered index)

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.