Tags » Microsoft SQL Server

Why shouldn't I shrink my database data file?

A while back I did a post about why you shouldn’t shrink your data file. This one is going to be similar in some ways, different in others. 840 more words

SQLServerPedia Syndication

Rx for Demystifying Index Tuning Decisions – Part 4

— by Jeffry Schwartz


In Parts 1 through 3 of this blog series the author discussed various aspects of SQL Server indices such as: 1,392 more words

SQL Server

Variables in Dynamic SQL

I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. I should point out here that I really enjoy dynamic SQL. 573 more words

SQLServerPedia Syndication

Learning to Give Presentations Well (Part 2)

In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3. In Part 2 we’re going to look at recommendations from… 802 more words


It takes a village

Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday… 671 more words

SQLServerPedia Syndication

Log shipping broken by memory dump. Part 2

It is about a month on and I have arrived at the office to discover that again our large, log shipped database has entered the suspect state following a memory dump. 224 more words