Tag Archives for " SQL Help "

Using sys.sql_expression_dependencies as a Single Source to Find Referenced and Referencing Objects

By Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server

I thought I would continue to expand on ways to view dependencies.  This post will give you an alternate way to find things referencing tables and finding things that are referenced by a stored procedure or view after my previous posts on the subject.  See these (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) A different way to find […]

Continue reading

SQL Toolkit – Get List of Database Options and Features

By 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 reading

Is This Database Being Used?

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

— By Ginger Keys During the migration of a client’s SQL environment to a new hosting provider it was questioned whether all of the databases needed to be migrated. Nobody seemed to know whether several of the databases were used or what they were for. One person suggested we just not move them, and see […]

Continue reading

Query Tuning – Adding Included Columns To An Existing Index

By Lori Brown | Intermediate , Performance Tuning , SQL Administration , SQL Development , SQL Server

— by Lori Brown @SQLSupahStah For the most part, I stick to my daily DBA duties of making sure that SQL Server maintenance is running and that the proverbial lights are on in all my SQL boxes. However, sometimes it is fun to do some tuning and it’s even better when you have a success. I […]

Continue reading

Synchronize Logins on AlwaysOn Replicas

By 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 reading

Script to De-Orphan SQL Logins

By 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 reading

Deadlock Info From system_health Information

By Lori Brown | Beginner , Helpful Scripts , SQL Administration , SQL Server

— by Lori Brown @SQLSupahStah Periodically, all DBA’s are going to run into code that fails due to a deadlock. Deadlocks happen when two or more SPIDs\sessions try to access a resource that is locked by each other. In short, something has to give so one is usually chosen by SQL to be the victim […]

Continue reading

My First SQL 2016 Management Studio Update

By SQLRx Admin | Beginner , Installation , SQL Administration , SQL Server

I opened my local SSMS today and found my first notification of an update to SQL 2016 Management Studio today. Here is what it looks like: When you click on update it takes you to MSDN to download the update. Apparently this one is a hotfix. Note that you do not have to download the […]

Continue reading

List Index Columns

By Lori Brown | Beginner , Miscellaneous , SQL Administration , SQL Development , SQL Server

— By Lori Brown @SQLSupahStah I was looking for a way to get info on the columns in indexes so that I could use the data to help enhance my index defrag routine. I found that my defrag logic did not figure out if an index has included columns that are LOBs and was failing […]

Continue reading