Tag Archives: mcm

T-SQL Tuesday #14–Resolutions

Posted on January 10, 2011 by way0utwest

It’s T-SQL Tuesday time again, and this month the Midnight DBAs (Jen’s blog | Sean’s blog | @MidnightDBA) are hosting the party. You can read about the whole T-SQL Tuesday blog party idea from Adam Machanic (blog, Twitter) if you … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

MCM Prep – Sliding the test

Posted on January 4, 2011 by way0utwest

If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night that I was scheduled for this Friday, but I’m nowhere near prepared. Not that I’ll be totally prepared, but I’d … Continue reading →

Posted in Blog | Tagged , | 1 Comment

MCM Prep – Only ONE Transaction Log File

Posted on January 4, 2011 by way0utwest

Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then … Continue reading →

Posted in Blog | Tagged , , | Comments Off on MCM Prep – Only ONE Transaction Log File

Quick MCM Prep Help

Posted on December 31, 2010 by way0utwest

Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4 or 5 before I left, dropping the MP3s on my iPhone, and I listened to a few of them on … Continue reading →

Posted in Blog | Tagged , | Comments Off on Quick MCM Prep Help