Tag Archives: administration

Balloons and Data

Posted on August 8, 2013 by way0utwest

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

Posted on July 15, 2013 by way0utwest

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

T-SQL Tuesday #44–Second Chances

Posted on July 9, 2013 by way0utwest

It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate, write a post on the topic and publish it on the second Tuesday of the month. If you’d like to … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

SQL Server Should Work for Us

Posted on June 19, 2013 by way0utwest

I ran across a post the other day from someone that was trying to find out why their maintenance plan failed. This person had received a failure notice from SQL Agent, which is good. We should all be aware of … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on SQL Server Should Work for Us