Data Masker for SQL Server–Syncing Values Across Rows

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...

What is the CXPACKET Wait Type?

This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...

Use Filtered Statistics to Improve Performance on Very Large Tables

Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...

Data Modeling for Self-Service BI @ Techorama 2018

I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018...

SQL Server and Evil Greedy Data Types

In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...

A Very Happy Holi – Festival of colors, Colors of life

New Built-in Function CONCAT_WS() – SQL Server 2017

In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...

A Swiss Army Knife Might Not Make the Best Shovel

You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal...