Oftentimes folks applaud PowerShell for things, and I see that those things can be done and automated just as easily in t-sql. I am looking for a list of...

Again (being the 4th person to ask), can I / how do I determine the user that made the change? Tx.

So Gail, to sum up:

(When and only when) we rebuild/reorganize the clustered index, we re-arrange the physical data pages on the disk. Correct?

"The next few times I connect with that person I try hard not to let that first perception define them."

I'm so glad that you do that. Unfortunatelly some people...

I'm having trouble with slow Update queries, and all the performance tuning articles talk about Select queries. Any link to tuning Update queries? Or should I post my...

context_info() is a good way to fake a global variable which is not available in sql. (something that will survive "go" and "use" statements).

Add a parameter @online to the stored procedure, and then change the statement building line to:

SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname +...

Rather than worrying about chip producing countries (and companies) gaining access to our data, worry about NSA and our phone companies outsorcing mass surveilance and data services to Israel, which...

Paul,

Makes sense. Ok, I won't stick to the 300 then, I'll look at a broader picture instead. The number seemed to fit for my 'up to 32GB of...

Paul,

Again, what you're saying is right, again, you're stating the obvious (IO subsystem could cause latency - who would have thought?), and again, you're missing my point. Or, ok,...

GilaMonster and Paul,

I understand the theory behind PLE well. I also agree, that a temporary drop even to 0 is ok (seen those many times). Paul, I know...

The author just gathered things that DBAs normally check into 1 piece, which is...

I totally disagree with people saying that PLE (Page Life Expectancy) of 300 is an irrelevant number and how we should all watch our servers and look for deviations from...

Mike Tutor (2/22/2010)

---

Thanks for the great script. I created a table with a capture date and put your script (with some minor modifications) into a weekly job. This...

Can you elaborate on:

"The effort required to locate an entry(s) in the index is less."

Thanks.