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…
Month: August 2011
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…
Dba’s Memory Assistant
I can’t always remember ok, make that i frequently forget things. Can i use SSMS to help me? Yes!
Error formatting query, probably invalid parameters
Ok, so what the heck does that error mean?
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…