Everything is exactly the same to my eye.  It could be that the settings on the ESXI could be different, but I've been assured that's not the case.

Yes, that's correct, but the index itselft is composed only of that bigint.

OK, so we're running the automated script that determines which indexes need to be rebuild and tries rebuilding them. For some reason the script logs to the table that...

We don't shrink this db at all.

My guess is that when the db was setup nobody played with fill factor settings and it shows up as 0 on the fragmentation report that I now run once...

The strange thing is that one of the tables in particular, the one which contains over 400k pages and is 3.8GB in size doesn't grow all that much. There...

It's a clustered index. Not a heap table.

The log files are on two different drives. It's native storage in RAID1 config. The data files are located on different drive and that's RAID5. We're seeing...

Each proc that runs returns the amount of time it took to complete and saves this information to the audit table. With a single log file the execution is...

I'm really interested in new functionality, but I can't seem to find a good spec list. I did review the differences on MS web site, but so far it...

LutzM (5/28/2011)

A nightly job taking several days? I truly hope this...

We don't use Full Text Catalogs and the problem still exists. We found a temporary workaround but its not the best. I'm not sure why the query processor...

It did get fixed. It was a third party .net DLL which we used for search. We fixed it by writing our own search engine.

Thanks. I'm basically converting SQL statements to SQL server from mysql and making sure that all the data matches. I'm not sure what my answer to dev group...

Why...