Checkpoints and the Lazy writer

Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...

Foreign Keys Help Performance

I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...

I’m an ACE

I am happy to announce that I’ll be joining Idera’s Advisor & Community Educator for SQL Server program.

Getting More Involved
I’ve always...

I’ve got 99 Problems, but a disk ain’t one

Tom LaRock has a new meme for Meme Monday. It’s all about the problems caused in your system other than...

Meme Monday – “I got 99 problems but a disk ain’t one”

Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter)  has started.  Today he has started things off with a list of things that...

Meme Monday – “I got 99 problems but a disk ain’t one”

Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post.  The question for today is: how many...

Meme Monday – “I got 99 problems but a disk ain’t one”

Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter)  has started.  Today he has started...

Meme Monday – “I got 99 problems but a disk ain’t one”

G’day,
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been...

Meme Monday: 99 Problems

Tom LaRock's (Blog | @SQLRockstar) latest Meme Monday challenge asks: "how many things can go wrong with a database server that...

Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One

From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...