You might also get: “The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer.” To resolve this… Continue reading “New 2008 r2 Install SSIS “Failed to retrieve data for this request.””
Drop user who owns a Schema
How often are you deleting users and you get the warning that this user owns a schema and the schema is going to get dropped also…and are you sure you want to do this? … And no, you’re not really sure about the schema? Continue reading “Drop user who owns a Schema”
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 like‘[A-Z][A-Z][A-Z][0-9]’
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 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”
Dba’s Memory Assistant
I 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”
Error formatting query, probably invalid parameters
Ok, so what the heck does that error mean? Continue reading “Error formatting query, probably invalid parameters”
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
run the following command (from a DOS box):
REGSVR32.EXE dts.dll
15 seconds later you should get a window stating it was successful.
Importing data from Excel
Importing data from excel is very easy and you have several options to get you started… Continue reading “Importing data from Excel”
See your servers’ performance real-time
I have posted an article to enable you to compare your servers’ performance in real time. It’s one of my favorites. It won’t run on systems older than 2005. You’ll find it here.
Why can’t I see more job history?
I’ve been a DBA for a long time… and it still takes me a minute of thinking before I remember how to see more job history. Furthermore, it takes a second try before I remember that the “Maximum job history rows per job” is the number of steps * the number of job runs. So, if each job run has 100 steps, and your setting (as below) is “200” for the “Max rows per job”, then you’re only going to see 2 job runs in history. Continue reading “Why can’t I see more job history?”