Archive for May, 2011
The Rose City
I’m off to Portland, Oregon for a few days for some much-needed R&R.В I’m *so* looking forward to some of this A little of this And, yes, a bit of this Oh!В and I have to try one of these! ‘Til next week, folks…
May 9, 2011
Tags: vacation Posted in: Uncategorized 
One Comment
Scripting out a database
Switching gears a little bit, much of my attention this week has revolved around backups. We have several large databases that have gotten to the point where full backups every night have become unwieldy. So I’ve been redesigning the maintenance plans for them around a full backup once a week and differentials nightly. So far [...]
May 5, 2011
Tags: backups, powershell, scripts Posted in: Features, General, Maintenance 3 Comments
How is SQL Server using all that memory, anyway?
I want to stick with the subject of memory because I think it’s probably the most misunderstood (and sometimes downright mysterious) component of SQL Server. I know I, for one, could benefit from a better understanding of its inner workings. So today I’d like to share that little bit of code I mentioned last week, [...]
May 2, 2011
Tags: buffer pool, DMVs, memory, procedure cache Posted in: General, SQL Tuning, Troubleshooting No Comments
