By Lori Brown | Beginner , Helpful Scripts , Performance Tuning , SQL Administration , SQL Server , Tip of the Month
While not having enough indexes can be bad for query performance, having too many indexes can also be just as bad. Use the query below to get a list of tables in your database that has more than 10 indexes. — Tables with large number of indexes select t.name as TablesWithLargeNumInx, count(i.name) as CountIndexes from […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
–By Lori Brown I am going to start up a thread with some queries that I consider to be important to DBA’s. As a consultant, many times we have to start managing SQL instances without any knowledge of why it has been configured in various ways. We usually try to work with our clients to […]
Continue readingBy Ginger Daniel | Helpful Scripts , Intermediate , SQL Administration , SQL Server
-by Ginger Keys It is not uncommon for database files to grow to the point you need more disk space. But what if it’s not possible or not in the budget to add more space? There are several creative options you have to move or shrink files, or delete unneeded items from the disk. One […]
Continue readingBy Lori Brown | Expert , SQL 2016 , SQL Development , SQL Server , SSIS Catalog
–By Lori Brown @SQLSupahStah I have a client who has a lot of SSIS packages in the SSIS catalog that we are migrating to a new server. Of course there is lots of testing going on. So the question came up about how to more easily see package runtimes and comparing to the overall average […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah I needed to update some of our long running job monitoring code to improve it from the version that we have right now. I like this version because it uses msdb.dbo.syssessions (https://msdn.microsoft.com/en-us/library/ms175016.aspx) to validate that a job is actually running. I also wanted to know the percent difference between the current […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , Security , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah At one of my clients who has an AlwaysOn failover cluster, I noticed as I was checking up on things on the secondary replica that there were several fewer Windows and SQL logins on the secondary than on the primary. I really did not want to tediously compare the logins on […]
Continue readingBy Lori Brown | Intermediate , Security , SQL Administration , SQL Server , Upgrade
–By Lori Brown @SQLSupahStah I am working with a client who is migrating from SQL 2012 to SQL 2016. It just so happens that while they have just a few databases to move, they also have a ton of SQL logins that needed to be migrated. This is not an issue since I know to […]
Continue readingBy Jeffry Schwartz | Expert , Miscellaneous , Performance Tuning , SQL Development , SQL Server
The following testing and resulting data is a direct result of a recent issue that was discovered at one of our client sites. After setting up SQL monitoring that does use a SQL trace to capture long running queries, suddenly certain processes would lock up and be unable to complete. Initially we thought it was […]
Continue readingBy Lori Brown | Offer , Performance Tuning , SQL Administration , SQL Server , SQLRX
SQLRx (@SQLRX) is proud to announce that two of our resident SQL Experts will be presenting sessions at SQL Saturday #515 in Baton Rouge, LA on August 6, 2016. If you have not signed up to attend, you are going to miss out!! http://www.sqlsaturday.com/515/eventhome.aspx Lori Brown (@SQLSupahStah) will give a lesson on how to be […]
Continue reading