Change Tracking is a great feature on SQL Server, but it can have some performance implications. It is however one of those features that doesn’t jump out as obvious if it is enabled until you start digging around on the table properties dialog. Here is where you can find it for a specific table. But what if I don’t have …
Find all tables with Change Tracking on your SQL Server Read more »
Today I released the November 2018 (version 2.6.6) release of Database Health Monitor. Version 2.6.6 Release Notes Version 2.6.6 is the November 2018 Release of Database Health Monitor New Features in 2.6.6 Added a check in the Quick Scan report for databases running on an older compatibility level. Added a check to the Quick Scan report for serializable transactions. Added …
Released Today – Database Health Monitor – November 2018 Read more »
The SQL Server compatibility level is a SQL Server setting. This is the setting that controls some of the features of how the SQL Server database engine runs, for instance the cardinality estimator. Some people have found problems with certain queries when updating to SQL Server 2016 for instance due to the changes in the cardinality estimator. If you …
Find databases running on an older compatibility level Read more »
It can be frustrating to find recently failed jobs in the job history in SQL Server Management Studio. A quicker way to do it is to just run a query to see what jobs have failed recently. The following query shows the jobs that have failed in the last 24 hours. This query has been tested on SQL Server …
With SQL Server 2019, there is a new compatibility level introduced, level 150 the new SQL Server 2019 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL …
Today I had the opportunity to present at PASS Summit in Seattle. My presentation was on Friday afternoon in room 6E. This room was huge, the largest room that I have had a chance to present it at PASS Summit. And here I am minutes before the session started. The presentation was on SQL Server Join types, …
In preparation for my PASS Summit 2018 presentation on Friday, here is an updated version of the SQL Server JOIN Types poster Try our JOIN Types Course: Comes Complete with: • Easy to understand lectures with examples • Assignments • Sample code to work with
It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion leads to the pros versus cons of each. The need to apply updates and the balance with the business requirements. Pros and Cons of Windows and SQL Server updates on Production SQL Servers: PRO: Service …
Latest Service Packs – To Install or Not to Install? Read more »
If you are going to PASS Summit 2018, please come and see my Exploring SQL Server JOIN Types presentation on Friday afternoon. Check out our SQL Server JOIN Types Course Comes Complete with: • Easy to understand lectures with examples • Assignments • Sample code to work with
Today I have the opportunity to release Database Health monitor version 2.6.5. It has been just a few weeks since the August release, but I did have a chance to build in a few new features shown below. Version 2.6.5 Release Notes Version 2.6.5 is the September 2018 Release of Database Health Monitor New Features in 2.6.5 The QuickScan report …
Database Health Monitor September Release Now Available Read more »