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

DotNine SQL Server and more

I am a database specialist from the Netherland with my main focus on Microsoft SQL Server. My IT career began 14 years ago as a System Administrator. I have been working with SQL Server for more then 10 years now and a full time DBA for 5 years.

Archives: February 2014

Why wait statistics are important and how you can start collecting them now!

Why wait statistics are important and how you can start collecting them now!

Wait statistics have always been a very important tool in troubleshooting complex performance issues or monitoring the impact of changes on your SQL Server. I use wait statistics daily in helping clients troubleshoot performance issues they are…

Read more

0 comments, 146 reads

Posted in DotNine SQL Server and more on 28 February 2014

Restoring Filegroup backups on another server, and why it won’t work…

We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.

One of the SQL Server hosts the primary copy of the AdventureWorks2012 database which gets restored every night to the other SQL Server as a secondary copy for development use.

One… Read more

0 comments, 22 reads

Posted in DotNine SQL Server and more on 20 February 2014

Restoring Filegroup backups on another server, and why it won't work...

We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.

One of the SQL Server hosts the primary copy of the AdventureWorks2012 database which gets restored every night to the other SQL Server as a secondary copy for development use.

One…

Read more

0 comments, 206 reads

Posted in DotNine SQL Server and more on 20 February 2014