Window Function Basics – PARTITION BY
One of the things that I’ve done over the last year to improve my T-SQL skills is learn […]
t-sql
Time Series Data Mining Example with T-SQL when Adding New ...
The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.
Ensuring a Single Row Table
Single row tables in data modeling Single row tables are a fact of our life as as a […]
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
Efficient Table Migration to a New Schema in T-SQL
Introduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and […]
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
Alternatives To SQL Server 2022 Built-in function GREATEST
The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral.
The Basics of Using GENERATE_SERIES()
First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one […]
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
Different Ways to Format Currency Output in SQL
The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Sample Use Case for Using SQLCMD Utility Batch Files
The post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral.
FOR XML PATH Changed The Way I Think About T-SQL ...
The first time I saw FOR XML PATH being used to generate a comma-delimited list, I think I […]
Get the Most Current Row From a Detail Table
Task: Update a table with the most current value of a detail table. In this article I’m using […]
Starter Metadata T-SQL Query Examples for Databases and Tables
The post Starter Metadata T-SQL Query Examples for Databases and Tables appeared first on SQLServerCentral.
Horizontal Trees
Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent […]
Common Table Expression Basics
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […]
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […]
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Passing parameters to query without TVFs
Problem Statement You have a need to extract data from a table or view with 1 or more […]
ChatGPT in SQL Server – Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL […]
Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […]
Find 40 Problems in This Stored Procedure.
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […]
3 Ways to Debug T-SQL Code
Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers […]
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table […]
Should You Use SQL Server 2022’s STRING_SPLIT?
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to […]
Should You Use SQL Server 2022’s DATETRUNC?
SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, […]
Getting started with ROUND() and Its Use Cases
In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function […]
Slow “Having” Query? Try Pre-Filtering.
I was helping a client with a query, and I’m going to rework the example to use the […]
How to get IO statistics of SQL Server database files
SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with […]
SQL Cheat Sheet for Basic T-SQL Commands
The post SQL Cheat Sheet for Basic T-SQL Commands appeared first on SQLServerCentral.
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE […]
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Data Lineage is a process of understanding data’s lifecycle, from origin to destination. It tracks where data originates, […]