By Lori Brown | Helpful Scripts , Maintenance , SQL Maintenance , SQL Server
I have a customer who let me know that some of their tables had a large amount of unused space in them. They were wondering if I could get them to release the space. After doing some investigation, I found that all tables with the huge amount of unused space were heap tables. I advised […]
Continue readingBy Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server
Since I seem to run across lots of questions about how to make sure that no jobs get in the way of ETL or other stressful data loads, I thought that I should post some ways you can stop jobs. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-stop-job-transact-sql?view=sql-server-ver16 I have always done this by having a monitoring job that executes on a […]
Continue readingBy Lori Brown | Helpful Scripts , Indexes , Replication , SQL Server
Problem Have you ever had transactional replication mysteriously start showing significant latency at a subscriber server? If so, check to see if the primary keys from the publisher database are missing on the subscriber database! Replication was showing long latency while the publisher and subscriber servers were not heavily utilized. Microsoft generated stored procedures that […]
Continue readingBy Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server
On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete. I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang. Since the issue only occurred intermittently, […]
Continue readingBy Lori Brown | Function , Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
This is kind of a continuation of one of my previous posts. (https://www.sqlrx.com/find-and-modify-file-growth-settings-for-all-databases/ ) Thousands of databases in a SQL instance can make a DBA’s life a bit challenging. Automation suddenly becomes very important. My new client had been shrinking their databases frequently, mistakenly thinking that doing so was a good thing. I needed to […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server
I have a client who is challenging me in a lot of ways. They have over a thousand databases in one of their 2 SQL instances. Over. A. Thousand. Admittedly, the databases are not big but the sheer quantity of them is daunting to say the least. To make it more fun, some of the […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server
I have been working on some improvements to some of the regular ways we monitor for important changes. We always have to be on the lookout for unexpected changes being made in the SQL instances that we monitor since often times we are not the only team who has sysadmin access to the instance. We […]
Continue readingBy Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server
Hooray!! We finally have our 70-764 and 70-765 certification exams done and can turn our attention back to blogging more regularly. Those exams were pretty tough mostly because there was a lot of information that had to be memorized since there are always aspects of SQL that we don’t regularly use and there is no […]
Continue readingBy Lori Brown | Helpful Scripts , Miscellaneous , SQL Administration , SQL Maintenance , SQL Server
This might be kind of basic but since I am working on a comprehensive script to discover things that a DBA really needs to know about, I made a couple of queries that will produce a list of the databases that have multiple files along with the locations of the physical files. One query finds […]
Continue reading