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 like‘[A-Z][A-Z][A-Z][0-9]’
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 needed some scripts that would allow me to monitor the process and verify that I could escape the vendor’s dire prediction. The scripts that follow did just that… Continue reading “Monitoring Log File Growth in SQL Server”
can’t always remember ok, make that i frequently forget things. Can i use SSMS to help me? Yes! Continue reading “Dba’s Memory Assistant”
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
run the following command (from a DOS box):
15 seconds later you should get a window stating it was successful.