DavidWimbush - All Comments

re: Transaction log growth in the model database

DavidWimbush — Mon, 11 Apr 2011 13:35:15 GMT

With hindsight it looks a bit silly. At the time it seemed like a good idea to set up regular backups of the system databases as well as our own databases.

re: Transaction log growth in the model database

GrumpyOldDBA — Wed, 30 Mar 2011 11:14:24 GMT

I have to ask the obvious question - why backup model unless you are making changes to it? I can't say I've ever backed up the model database, however I do use my own backup procs and I do have a backup exception table. It's not normally something you change very often so why back it up, or at all if you don't make changes to it.

Twitter Trackbacks for Slow in the app, fast in SSMS - DavidWimbush [sqlblogcasts.com] on Topsy.com

Thu, 24 Feb 2011 07:24:36 GMT

Pingback from Twitter Trackbacks for Slow in the app, fast in SSMS - DavidWimbush [sqlblogcasts.com] on Topsy.com

re: How to process a cube in a SQL Agent job

DavidWimbush — Wed, 23 Feb 2011 16:51:37 GMT

Thanks, samikane. I hadn't heard of that project. I'll be digging into that!

re: How to process a cube in a SQL Agent job

samikane — Wed, 23 Feb 2011 16:32:30 GMT

Here are some other articles on SSAS Processing: ssas-wiki.com/.../Articles

re: I love it when a plan comes together

GrumpyOldDBA — Wed, 08 Dec 2010 16:17:46 GMT

tending to look at things from a different view it was interesting to note that the query plans and io stats are identical to using in and not in statements, but I have only looked at a fairly superficial level. It possibly makes the code more readable, maybe even a bit procedural.

re: Strange but True: sp_ tables

GrumpyOldDBA — Mon, 27 Sep 2010 06:43:57 GMT

It's always been that way as far as I can remember.

re: In praise of the MVP Deep Dives book

sarveshsingh — Fri, 20 Aug 2010 14:38:30 GMT

I've got one of these.. It's a brilliant book.

re: Be careful with table variables

Dave Ballantyne — Wed, 21 Jul 2010 08:34:05 GMT

Rather than blog, ive done a cuppa corner

www.screencast.com/.../72b48209-5715-4352-8a59-445824377e83

re: Be careful with table variables

DavidWimbush — Fri, 16 Jul 2010 08:25:28 GMT

We've nearly got a book chapter here!