Dynamic Data Masking in the execution plan
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
811 reads
Bad indexing can show up in wait statistics
At first, this statement might sound a bit confusing. Usually, we expect wait statistics to show us what a query...
2019-02-06
211 reads
Two T-SQL features that I appreciate
We occasionally get cool improvements in T-SQL in newer versions of SQL Server. Here’s a short post on some of...
2019-02-05
178 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,104 reads
SQL Server Monitoring: Keeping track of missing index requests
A lot of us turn to execution plans when we see a slow running query, and it’s not uncommon to...
2019-02-04
186 reads
SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
366 reads
How many plans are in the plan cache for a stored procedure?
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
495 reads
Memory Grants part 3: How much memory can one query get?
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,918 reads
Query tuning: The IN clause
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,504 reads
It’s always parameter sniffing (part 1?)
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,025 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers