Well, I observe that there's a strange behaviour using this script on over than 100 tables. In fact SQL 2008 creates a #Worktable for the part "SELECT @tblSignature = @tblSignature...

Thanks a lot colin.Leversuch-Roberts for the answer you did.

No price to win 😉 , sorry.

As you wrote I'm not convinced myself that using a while loop (or a set)...

Jack Corbett (11/10/2009)

---

Actually if you use a server-side trace with only the sql:stmtcompleted event filtering on TextData you probably wouldn't even realize the trace is running. Are you aware...

Jack Corbett (11/10/2009)

---

Actually if you use a server-side trace with only the sql:stmtcompleted event filtering on TextData you probably wouldn't even realize the trace is running. Are you aware...

Hello Jack and Helliott,

Thanks for the feedback.

Jack I see the trace in the profiler (with no event) with object name as "ENABLE DISABLE TRIGGER". Thanks for the info. But it's...

Just use JKDefrag: http://www.kessels.com/JkDefrag/index.html.

JkDefrag is a disk defragmenter and optimizer for Windows 2000/2003/XP/Vista/2008/X64. Completely automatic and very easy to use, fast, low overhead, with several optimization strategies, and...

I always leave autogrowth on to cover potential unexpected events. But as I mentioned in my editorial, I don't recommend you use autogrowth to grow your files. You should actively...