Monthly Archives: August 2011

Character selection by location in a string

Suppose you had a 4 character field (prefx), and you wanted to find all those records where the 2nd and 4th characters were numeric, with the other two being alphabetic.  Here’s a neat, simple solution: select * from TableName where prefx … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Tagged | Leave a comment

Monitoring Log File Growth in SQL Server

We recently had to ‘migrate’ a vendor supplied database with a vendor-supplied process.  We were warned that the database log file could grow some 10,000% !!!!  Not finding that particularly palatable, I upped the transaction log backup to every minute.  I … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | 1 Comment

Dba’s Memory Assistant

I can’t always remember ok, make that i frequently forget things.   Can i use SSMS to help me?  Yes!

Posted in SQL 2008, SQL Administration | Tagged | Leave a comment

Error formatting query, probably invalid parameters

Ok, so what the heck does that error mean? 

Posted in SQL 2008 | 1 Comment

Creating an instance of the COM component Error with SSMS

For the 4th time, I’ve tried to open a job step and been prevented with this mysterious error “Creating an instance of the COM component” …  The fix is normally simple, just navigate to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and … Continue reading

Posted in SQL 2005, SQL 2008 | Tagged | Leave a comment