I have a lot of servers. Full-Text operations sort of slipped up on me. Then, a developer asked for assistance…in particular who else was using full-text that he could ask for guidance? I couldn’t tell him. That got me started…
Category: SQL Administration
New 2008 r2 Install SSIS “Failed to retrieve data for this request.”
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…
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…
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…
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!
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…
Reboot–the last resort
Simple, weird problem, long research, short answer. The other evening, “something strange” happened to one of my clustered (active-active) boxes. When i arrived in the morning, the linked servers from each of the nodes to the other node was failing with…
Determine Backup schedules across multiple SQL Servers
Today some architecture changes were scheduled to occur in the evening. I wanted to adjust or disable backup jobs that could be affected. I have some 50 SQL servers. I needed to know when the backups were to start on…