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 🙂

You're going to run into that problem because of the rule for the floating point. How about converting to decimal(38,17) from real before trying to cast it out to a...

Technically speaking, they are the same.

However, you're asking the wrong question. Why do you need to know whether it's the same? What is it that you're trying to find out?

CrazyMan (7/1/2009)

---

Thanks,i am only using 2 Quires to retrieve all my reports, each table has 30 columns, and db sits on a file group,

I am not using Union...