Steve, I hear where you're coming from, and I do think it's a nice to have, but the traditional approach of restoring from pre-upgrade backup would still be valid.

I think...

Steve, agreed, which is why I think it would be a useful feature, but difficult to implement for the alternative (i.e. using the new features). For that amount of effort,...

You can do an upgrade. I don't see the sense in uninstalling 2005 first.

While it would be a nice feature, I don't think it serves us well, especially with differences in datatypes between versions.

Sure you could try to force compatibility levels, but what...

Good tip, Steve! I completely forgot about that. I'm going to have a look myself. 🙂

I can't answer question 1, but regarding question 2, a checkpoint will automatically be called during a server shutdown. If you don't run a checkpoint, all the pages that have...

TechJunky (11/24/2009)

---

Any reason I can not use EXEC sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")' ?

After I run SHOWCONTIG they look fine afterwards.

I backed up and restored to a test server....

Howdy

The percentages I did in Excel after copying the results into a spreadsheet.

You could also download sp_waitstats.

First off, non-clustered indexes will be better. I don't even want to think how long it would take to build a clustered index.

You would have improved performance using table partitioning...

Simple recovery mode and batch inserts will probably be enough, without shrinking the logs, but as you say, this isn't production.

It's always interesting to do this sort of thing. My...

smunson (7/2/2009)

---

Well folks, things have definitely gotten interesting... I know that SQL Server has some level of overhead in a table, but I'm completely lost as to...

Stripe for speed, mirror for redundancy.

Partitioning is a whole nother kettle of fish. You can benefit from table partitioning as long as it's done sensibly.

Add this to your hosts file:

127.0.0.1 crl.microsoft.com

Then try again.

If this fixes it, it's the service trying to connect to the Internet, which the user doesn't have...

SQL 2005 includes the PIVOT keyword, which you can use in combination with SUMs and COUNTs and so on.

Or do it the hardcore way like Peso's example 🙂