Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2010

What is a Good Way to Run CheckDB on a VLDB?

Introduction

Today’s script is one that I wrote based on the logic outlined in this post by Paul Randal (Blog|Twitter). This script is written for SQL 2000 but, as Paul notes, the logic will work on SQL 2005.

The Script

This stored procedure stays pretty true… Read more

0 comments, 175 reads

Posted in Adventures in SQL on 21 May 2010

What 5 things should SQL Server get rid of?

Paul Randal (Blog|Twitter) recently kicked off this meme by listing the 5 things he thinks SQL Server should get rid of. Michelle Ufford (Blog|Twitter) tagged me on her response, so here is my list of 5 things I think SQL Server should… Read more

0 comments, 332 reads

Posted in Adventures in SQL on 20 May 2010

How Do I Move SQL Database Files Around?

Introduction

Today’s script is one that I had not planned on blogging so soon but since Paul Randal just talked about moving SQL Server files around for TechNet Magazine, it seemed like a good time to break this one out.

The Script

This script is a little different in… Read more

0 comments, 220 reads

Posted in Adventures in SQL on 11 May 2010

Where Do I Start with PowerShell?

Introduction

This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I threw the question out to the SQL Community on Twitter via #SqlHelp. The response was so overwhelming that I… Read more

0 comments, 1,263 reads

Posted in Adventures in SQL on 6 May 2010

How Can I Tell if SQL Agent is Running via SQL?

Introduction

Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my environment. To date it has been a great exercise both in getting things written down and in getting feedback from others on better ways I could be doing things.… Read more

0 comments, 145 reads

Posted in Adventures in SQL on 4 May 2010

What is a Good Way to Get the SQL Server Log Directory?

Introduction

Today’s post is going to be a quick one to get back in the saddle again. I have been on an involuntary hiatus from blogging due to production issues. Things are getting better so it seems like time to get back to blogging.

The script for today is one… Read more

0 comments, 156 reads

Posted in Adventures in SQL on 3 May 2010