Why don't you just use this one? Easier than writing and debugging your own.

http://sqlfool.com/2009/06/index-defrag-script-v30/

Index rebuilds always update stats with full scan, because the entire index is being read for the purposes of the rebuild.

Above 24 pages you may see a change in the fragmentation. The 1000 pages is more or less, somewhere around where there's a measurable performance impact from defragmenting.

If you want...

I take exception to that. 😉 :hehe:

Birthday

No.

ALTER VIEW <ViewName> AS

<Select Statement>

How would add column work? You're saying nothing about which table that column comes from. A view's just a saved select statement, it's got no...

However I have a policy whereby I do not answer questions sent...

A rough rule-of-thumb, given by a former program manager of the storage engine is around 1000 pages....

A quick look in Books Online under the topic 'sysprocesses' (http://msdn.microsoft.com/en-us/library/ms179881%28SQL.90%29.aspx) shows the following

Books Online

---

sys.sysprocesses

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend...

Depends on the type and severity of the corruption. Either's possible.

If the database has checksum page protection and the backup was done with the checksum option, then many forms of...

robert.jackson-943581 (12/7/2009)

---

However, it did not seem to answer my question, (which you now have) but reassured me about some others. Everything I had read mentionined it started a new log...

For sysprocesses either works, because it...

robert.jackson-943581 (12/7/2009)

---

1: A transaction log backup, apart from taking a backup of the transactions since the last full/log backup, also allowed those 'old' transactions to be overwritten so the...

Beautiful.

Grant Fritchey (12/7/2009)

---

Here's my IM address, just send me the questions and I'll plug in the answers... they'll all be 100% correct...