Tag Archives: administration

Patch Problems

I ran across this article a week or so ago, but hadn’t had a chance to put anything out. There were three patches put out in July for various products that caused issues with other software, one of which was SQL Server.  can … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Patch Problems

T-SQL Tuesday #45–Follow the Yellow Brick Road

It’s T-SQL Tuesday time again, and this month Mickey Stuewe hosts the party. It’s an interesting topic, and one that I think is important, and will be more important, as we capture, store, analyze, and depend on more and more … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Balloons and Data

We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some of the issues that many of us have dealt with repeatedly over the years. One of the more common questions that … Continue reading

Posted in Editorial | Tagged , | Comments Off on Balloons and Data

SQL Server Needs Tempdb

I saw a post recently where someone noted they had moved tempdb like this: USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘c:\tempdb.mdf’); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = ‘c:\templog.ldf’) … Continue reading

Posted in Blog | Tagged , | 1 Comment