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

Tim Radney - Database Professional

Tim Radney - Database Professional by Tim Radney I am a Sr DBA for a top 40 US bank. I live in the south eastern US. I have been working with database since 1999 but only full time for the past three years.

Archives: May 2012

SQL Saturday #167 – Columbus GA

The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus State University.  We currently have 5 classrooms reserved and have the ability to add a couple more if needed.  Each room holds over 40 people so our current capacity is… Read more

2 comments, 688 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

6 comments, 711 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Turn on Instant File Initialization for SQL Server Performance

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

1 comments, 2,597 reads

Posted in Tim Radney - Database Professional on 30 May 2012

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written.  He received an error, “cannot resolve collation conflict for equal to operator”.

Early in my career I had experienced the same issue so I quickly searched my code snippets and… Read more

0 comments, 560 reads

Posted in Tim Radney - Database Professional on 25 May 2012

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into a development environment you don’t care so you just restore… Read more

5 comments, 1,677 reads

Posted in Tim Radney - Database Professional on 21 May 2012

SQL Saturday 112 Recap

I had the pleasure of attending SQL Saturday 112 this past weekend.  This was my second time speaking at a SQL Saturday in Birmingham.  I was selected to present two sessions again this year in the first and second time slot.  I started off with “Getting Involved and Getting Ahead”.… Read more

0 comments, 334 reads

Posted in Tim Radney - Database Professional on 17 May 2012

It was time for an upgrade


I am not one of these anti PC sorta guys, but I do love my MacBook Pro.  I have owned a PC since 1993 when I got my Packard Bell 386 with Windows 3.1.  Even with my MacBook I have 9 Windows flavored VM’s on it.  To be honest, I… Read more

1 comments, 380 reads

Posted in Tim Radney - Database Professional on 5 May 2012