An unpatched 2000 SP4 is not a good place to be, especially if you are using AWE. There were some significant fixes posted to that subsystem, to the optimzer,...

Itzik and some other MVPs have been pushing hard for improvements such as the one I listed to Transact SQL. This is one of several they are pursuing. ...

Yes to 2005 SP3. And I want it MUCH more thoroughly tested than SP2 was!!!

This just back from Itzik. He states that the running totals problem can be solved by this construct:

Yes, that would be the missing ORDER BY and ROWS subclauses of...

I posted about this topic on the SQL Server MVP private forum. I will follow-up if anyone there comes up with anything. I specifically asked Iztik Ben-Gan if...

Yes - a clustered index scan IS literrally a full table scan.

Couldn't you have a scan running under NOLOCK be joined by a TABLOCKX scan?

I too missed the stated use of TABLOCKX, although that will reduce the usefulness of the query since I know I wouldn't allow that in MY production system unless it...

Few things to test:

1) read uncommited isolation level and also NOLOCKs (if not already tested)

2) snapshotted table, with modifications

3) partitioned tables

4) table spread across multiple file groups

5) Enterprise Edition where...

I can say with almost certainty that you were winding up with a query plan that included nested loops for LOTS of rows (also possibly on unindexed fields). Your...

Documentation (with examples) on DISKPART can be found by a search on support.microsoft.com or a general websearch.

I just now noticed that you specified UPPER levels of the indexes. Do you have the Pad Index option turned on?

See BOL for CREATE INDEX and ALTER DATABASE. Also note that if your LUN isn't on different spindles you may not receive quite the perf boost you were hoping...

Imke Cronje (1/28/2008)

---

Am busy running DBCC ShowContig at the moment. Taking quite long.

Checked out execution plan and its shows this:

Query Cost (relative to batch) : 100%

Estimated Operator Cost: 99...

We defrag to remove frag. :w00t:

Fragmentation takes several forms. Basically when data is either not on disk sequentially or is out-of-order internally on the pages is fragmentation. ...