Monthly Archives: February 2012

Open file dialog shortcuts

File this one under nifty tricks. When you select open file from SQL Server Management Studio you get a familiar dialog box with three shortcuts down the left hand side. Desktop, My Projects & My Computer. You can add your … Continue reading

Posted in SQL Server | 1 Comment

Instant file initialization

A call came in to increase a database datafile by 7-8GB. I was asked if there were any implications of doing the increase. Of course the biggest concern was around creating IO load. One way to mitigate this would be … Continue reading

Posted in Database options, SQL Server | 2 Comments

SQL Server subsystems

When SQL Server starts it loads the location of 12 external subsystem dll and exe files into a table in msdb. You can view the contents of this table with this query: select * from msdb..syssubsystems or exec msdb..sp_enum_sqlagent_subsystems There … Continue reading

Posted in SQL Server | Leave a comment

{guid} cannot be opened. An error is preventing this key from being opened. Details: Access is denied.

Here’s the setup. I’m not a fan of virtual machines so I tend to install stuff on the metal. My laptop is my sandbox and test machine, I’m running 64bit Windows 7 Enterprise N. A wee while ago I had … Continue reading

Posted in SQL Server | 3 Comments