Wayne Sheffield

My blog about SQL Server

Browsing Posts in SQL

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a virtual tally table and pivoting data

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a running total calculation and duplicating a result set

Exploring how a parent-child relationship was implemented by a third-party software vendor improperly.

Understanding the relationship between statistics, indexes and constraints in SQL Server. What meaning does stats_id of 1 mean?

Performance testing various methods for removing the time element from the datetime data type. While they all execute quickly, one method is faster than the others.

It used to be hard to remove an old server from the SSMS connection dialog. Now, it’s easy-peasy. This blog post shows you how to perform this frequently needed action.

The internet has many examples of temporary table usage, including ways of checking for temporary table existence. It is unfortunate that many of these ways are wrong. This article will go over why these methods are wrong, and it will conclude by showing the proper way of checking for temporary table existence.

When you have an Availability Group, you will end up with jobs that you want to run only on the primary replica. Yet, the job should be installed identically on all replicas. This post shows several methods of creating primary replica jobs that will only run on the primary replica.

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify that this account: Has the […]

SSMS 17.3 SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention: Import Flat File Wizard XEvent Profiler Import Flat File Wizard If you’ve worked with SQL Server for very long, you have most likely needed to import flat files from time to time. SSMS 17.3 utilizes […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close