I wonder if this works the same way without ANSI Nulls? I'm too lazy/busy to try it out.

Oops, mistook the word "every" for "any" in the candidate key answers.

As George stated, is the rollback completion increasing?

I think I may need eye glasses, I really had to look hard at the commas to differentiate them from periods... I almost chose the Incorrect Syntax error.

You're right the one can't declare and assign in the same line with local variables in SQL 2005. Adding that feature in SQL 2008 made turning ad-hoc versions of...

Hello I noticed in the article that you say the test database will be called MyTesting, however the script creates it as TestDB. Just thought I'd point this out....

On the last point: the logging associated with sorting and building the index structure in tempdb is logged in tempdb as you would expect. Nevertheless, once the index is...

Paul White NZ (9/8/2010)

---

Charles,

Can you confirm that you are only running the REBUILDs and not the REORGANIZEs when you see this logging behaviour? Reorganize operations are obviously always fully...

Thanks Hai,

We actually do exclude the largest index in our database from the rebuild/reorganize job and have been doing so for some time. The index in question though was...

Derrick Smith (9/7/2010)

---

What is the size of all indexes together/size of the table?

sort_in_tempdb does in fact move the logging process for indexing to tempdb, but if it's on full recovery,...

Yes David, we do have to be able to perform...

Hi, you have two questions here:

1.) Is it possible to process an XML input to a stored procedure. Answer: Yes, see below.

2.) How do you process each line...

Hi David, Thanks for the post, I have considered switching to bulk-logged, but our business model requires us to be in full at all times. I suppose I should...

Hi Howard, thanks for your response.

No, we don't have any servers that still run 2005, but your explanation makes the most sense to what is happening on the server. ...

Jason,

I'm running this against just one index when I do so manually.

Henners,

Yes the user database is run in SQL Server 2008 (100) compatibility mode.

Thanks for the responses.