SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info
There was a time when SQL Server used to run on only Microsoft Windows. However, the time has changed, and SQL Server now runs on Linux as well. This is indeed a great move as I believe database such as SQL Server should be running on multiple platform …
SQL Server Cumulative Updates (January 2018)
Microsoft has released the following Cumulative Updates for SQL Server:Cumulative Update 3 for SQL Server 2017 RTMKB 4052987DownloadBuild number: 14.0.3015.40SQL Release Services Blog PostCumulative Update 7 for SQL Server 2016 SP1KB 4057119D …
SQL Server: Avoiding a Sort with Descending Order
In this month’s column I focus on queries that need to process data in descending order.
How Much Can One Row Change A Plan, Part 4
Monte Carlo Or Bust In Part 3, I showed you how two queries with TOP clauses can produce wildly different plans. To figure some stuff out about why the plans changed, let’s focus on the Nested Loops Join plan. Why? Because when I force the Hash J …
A new home for my SQLBlog content…
I’ve moved my content over to sqlblog.org . Read more details……(read more)
How to identify blocking in SQL Server
Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes.
Keeping track of history: SQL Compare and Temporal Tables
SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for tha …
Data Quality Components for SQL Server
Sponsored by: Melissa
SQL Server Intergration Services
Sponsored by: Melissa
SQL SERVER – How to Make SQL Server GDPR Compliance?
I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union. It is qui …
Checking Your SQL Server Instance for Spectre/Meltdown Patches
If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems from the Meltdown and Spectre vulnerabilities. Microsoft has a number of KB articles that address this issue from …
How Much Can One Row Change A Plan, Part 3
All The Rage We’ve asked how much one column and even one row can change a plan before. The doctor says I’m not allowed to read blog comments anymore on account of my blood pressure, but the AI I wrote in PowerShell assures me the …
Finding code smells using SQL Prompt: old-style join syntax
SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax – here’s how it works.
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
SQL SERVER – Activity Monitor – Active Expensive Queries
Recently during Comprehensive Database Performance Health Check, I had a fascinating conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. …