Tag Archives: SQL Server 2014

The TImes, They Are A-Changing

No, not the song. Nor the reference in Watchmen. But the clocks. Y’know, that primitive thing where we have to put the clocks back an hour in the winter and push them forward an hour in the spring? That. What … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

SQL Server TempDB, Azure Virtual Machines, and the D: Drive

Why put the TempDB on the D: drive? In the wonderful world of Azure Virtual Machines, for certain VM types, the D: drive is hosted on SSDs – great for performance. However, in this world, the D: drive is “non-persistent … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Possible SQL Server Trace Flag Gotcha

I was trying to turn on Traceflag 3226 in order to suppress the swarm of successful transaction log backup messages that floods the SQL Server (Error) Logs (& Windows Application logs). After all, if you’ve got more than a few … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | 1 Comment