Nope. Someone asked me the...

Stefan Krzywicki (10/28/2010)

---

Brandie Tarvin (10/28/2010)

---

Sean,

Thanks for pointing out that he's talking about syntax, but when I go back to read his post, he's saying ANSI is more readable than T-SQL.

I...

Agreed...and the whole lack of a 64bit jetdb...

Did you try right clicking and doing Rescan Disks?

Did you also check it in diskpart to see if you get the same results there?

Export to flat files...I hate dealing with Excel and would always recommend against it unless there is no other way. If you install excel 2007/2010 you can export more than...

It has to do with significant digits and rounding.

If you do select 5/2, you get 2 because it truncates.

If you do select 5.0/2.0, you get 2.500000, which is more accurate.

edit:...

First things first, look at the execution plan. See where it's hanging.

If you don't see anything there, check for blocks while it executes.

If that also looks fine, check CPU/IO usage...

That's because the excel format is %, essentially divided by...

Agreed - Numeric(4,2) or FLOAT.

Just for the record, getdate() and current_timestamp perform the exact same operation on the back end, so there is no data/performance difference at all between them. The only difference is...

edit: i lied, apparently there is now:

dbcc show_statistics ("HealthCheck", "idxTime") WITH STAT_HEADER

This will return just the top section. You can set that up with an insert into exec ('') loop.

If you have a freshly cleaned/formatted disk, and you copy new files to it, they will be 100% contiguous after the copy.

Yes, you can buy 2008. It's just called SQL Server 2008. R2 is an entirely different version with different install media/etc. There is no way to patch/update 2008 to be...

Yes you are.

The log restores will keep the database up to date. There is never a need...

Out of curiosity...are you executing this on your machine locally connected to a remote server and pulling results over the WAN?