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...

Reporting services error: User XXXX does not have required permissions

If you encounter the following error trying to access reporting services:

User XXXX does not have required permissions. Verify that sufficient...

SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...

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...

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...

Using a gMSA with SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While...

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...

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...

YouTube Channel Update

Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...

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...