Welcome to SqlAdvice Sign in | Join | Help

August 2007 - Posts

Monday, August 20, 2007 5:19 PM

Move TempDB Sql Server 2005

I recently needed to move the TempDB on my Sql Server so I looked in Books Online and my initial thought based on what it said was that there is no way that will work. Basically it says to find where the files are, and then move them to the new location
Posted by gstark | 3 Comments
Tuesday, August 07, 2007 10:37 AM

Recover Suspect SQL Server Database

Where I work we have about 160 instances of SQL Server Express running on laptops and as you can imagine these database instances tend to become corrupted from time to time. One of the most frequent issues is that a database becomes suspect. Obviously
Posted by gstark | 0 Comments
Friday, August 03, 2007 2:32 PM

SQL Server Management Studio Query Shortcuts

I have always hated typing and using the mouse so I always try to find shortcuts and hotkeys for every development environment I am in. Having said that I thought that I would share what I have custom setup for SQL Server Management Studio. Until I started
Posted by gstark | 9 Comments