Robert Davis

  • Interests: Poker, computers, reading/writing horror fiction

Technical Article

Check and Set Default file Locations with TSQL

Checks the default file locations for your data and log files. If not set, it sets them to the specified values. This is written for a SQL 2005 default instance. Registry paths may be different for SQL 2000 or named instances.The script can be easily modified to update it if the current value is set […]

4.5 (2)

2007-01-01 (first published: )

862 reads


My Toolbox - Greenshot


Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Daily Coping 11 Aug 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using DBCC CLONEDATABASE to create a schema only copy of your database.


DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...

Read the latest Blogs


MS SQL Server licensing questions.

By ehansigno

I inherited a fairly large system with a couple dozen servers (1/4 physical, the...

Python in Power BI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Python in Power BI

Metrics that matter for IT organizations on an agile journey

By Additional Articles

Comments posted to this topic are about the item Metrics that matter for IT...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers