AmolNaik (9/29/2010)

---

Create copy of the table that is identically same with the correct structure. Copy data from the existing table to this new table. Switch the table names.

After that you...

I figured I'd eventually get the pork chop thing from context eventually... but... yeah, I'm not. Where'd this originate? I've got the generic idea but still a little...

SQLBill (9/29/2010)

---

I don't mind working extra hours when needed and my wife supports me in that. It is interesting how lots of companies expect their employees to work extra...

WayneS (9/28/2010)

---

With all this talk about the clustered index, and churn on the date field, don't forget that all of those numerous non-clustered indexes will be converted to carrying the...

Logical disks are only useful for logical storage. It will give you no performance boost. Regarding the giant RAID 5 array, you'll want to find out if the...

I'm staring at a case for the need right now: The dependency broke across a linked server.

scott.pletcher (9/27/2010)

---

I don't object to an IDENTITY column in tables per se, and they have very legitimate uses.

But I dislike the idea that the default for a clus index should...

If the data from...

Can you alter the database engine/remote connections to local connections only via the surface area configuration? Will this work for the MDSE engine?

Best I can come up with. ...

Double post, sorry. Dunno how I pulled that off.

jordantx (9/24/2010)

---

Thanks for the replies so far...

The Widgets table has no clustered index. The WidgetDate field is the single most relevant column for searching/querying, however it can change often...

Not sure what all you've looked into yet, sure you've exhausted a lot, buuut:

Is there a lot of databases on this server? http://support.microsoft.com/kb/316749 (near the bottom)

Looking at the error log...

So this also needs to be...

jordantx (9/24/2010)

---

In the temp table version of my code, will SQL Server limit the rows it reads from Widgets to only those which are also in #tmpIDs BEFORE it tries...

Heh, sorry, for summary by column do all your row summary/setup the entire structure, then union to the tail (adding a hardvalued sortby column, per query, if necessary, to keep...