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.

How wait statistics are generated

How wait statistics are generated

In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a method of capturing wait statistics and a way to analyze them. Some background information on how wait statistics are generated by the SQLOS…

Read more

0 comments, 89 reads

Posted in DotNine SQL Server and more on 6 March 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, 131 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, 16 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, 181 reads

Posted in DotNine SQL Server and more on 20 February 2014

SQL Server Quick Tip: Growing your database past 2TB on SQL Server 2008

A couple of days ago I had to manually grow the database data file for a client, they do not use autogrowth and plan growth events. They are running on a SQL Server 2008R2.
The database data file was 1,9TB before the growth event, since we always increase the data…

Read more

0 comments, 91 reads

Posted in DotNine SQL Server and more on 14 January 2014

A Tour of the Transaction Log: Part 3 Reading Log Backups

In part one and two of our Tour of the Transaction Log articles we focused on reading events from the active transaction log, there can be times when that will not be enough and we actually have to dig deeper into transaction log backups to find the information we need.

Read more

0 comments, 85 reads

Posted in DotNine SQL Server and more on 15 November 2013

A tour of the transaction log : Part 2 DELETE operations

In the last Tour of the Transaction Log we looked at how INSERT operations behave in the transaction log.
In this part we will be looking at DELETE statements and how we can find out who deleted that record in your table!

Again, commands in this article are undocumented by…

Read more

0 comments, 71 reads

Posted in DotNine SQL Server and more on 4 November 2013

A tour of the transaction log: Part 1 INSERT operations

The transaction log is a very important part of SQL Server. Every data modification operation is logged in the transaction log before being ‘hardened’ to the database file.

There are plenty of scenarios where you might take a look at the transaction log like point-in-time transaction log backup restores (to…

Read more

0 comments, 70 reads

Posted in DotNine SQL Server and more on 7 September 2013

Optimizing SQL Server Backup and Restore

When your databases grow, operations, like a database backup and restore, are going to take a longer time to complete. Maybe at some point you are running out of your time window to complete a database backup or a restore. Instead of expending your time window (if that is even…

Read more

0 comments, 129 reads

Posted in DotNine SQL Server and more on 21 August 2013

How implicit data type conversion slows down your query

Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But as you will soon find out while reading this article it is one of those small tweaks that can increase the performance of your query!

Implicit data type conversion happens…

Read more

0 comments, 96 reads

Posted in DotNine SQL Server and more on 8 August 2013

Newer posts