By Ginger Daniel | Miscellaneous , Performance Tuning , Query Tuning , SQL Development , SQL Server
Jobs on a SQL server can take milliseconds or minutes to complete depending on the size and complexity of your query and also the SQL environment on which it’s executing. It’s important to have a baseline or at least be familiar with the normal amount of time your SQL jobs take to execute. For a […]
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 readingBy Lori Brown | Dependencies , Miscellaneous , Object Information , SQL Development , SQL Server
I have been working on some things lately that have required that I find objects with specific data types and collations and then find those objects dependent objects and anything else that uses those objects. My end goal was to ultimately create drop and create statements for the things I found since we were changing […]
Continue readingBy Lori Brown | ColumnStore , Miscellaneous , SQL Administration , SQL Server
I was recently looking at a way to easily identify if any objects in a database were In-Memory. Since many times I am tasked with taking on systems that I have never seen before, I have learned that it is important to have ways of checking to see if some of the more specialized features […]
Continue readingBy Ginger Daniel | Helpful Scripts , Miscellaneous , SQL Administration , SQL Server
If you ever have a need to monitor connections to your SQL server, and any related information about the connections such as database, logins, etc., there are some DMVs that can give you tons of information. Previously you might have used the sys.sysprocesses table to derive much of this information, but this is being deprecated […]
Continue readingBy SQLRx Admin | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
Find out if any of tables in your database have special features enabled using the queries below. These features need to be understood and carefully managed. — CDC Enabled Tables select distinct t.name AS CDCTables from sys.tables t where t.is_tracked_by_cdc = 1 — File Tables — SQL 2012 + select distinct t.name AS FileTables from […]
Continue readingBy SQLRx Admin | Miscellaneous , SQL 2017 , SQL Server
Since we at SQLRX have been super busy this week and still need to do something for a blog post, I thought that doing a link round up of new dynamic management views that are going to be available in SQL 2017 would be a quick and good idea. I am really interested in sys.dm_db_log_info […]
Continue readingBy 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 readingBy Ginger Daniel | Beginner , Miscellaneous , Security , SQL Administration , SQL Server
–By Ginger Keys After migrating a client’s SQL instances to VMs from physical servers, I noticed the following week that the SQL Server Log files had tons of failed login attempts from what looked like an application. These attempts were happening several times per second, and had totally bloated the SQL Server logs. This is […]
Continue reading