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.
t-sql
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, […]
#tsql2sday: Start Your Dynamic SQL with a Comment.
When you write dynamic SQL, start like this: CREATE OR ALTER PROC dbo.MyProc AS BEGIN DECLARE @StringToExecute NVARCHAR(4000); […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
T-SQL Language Changes in SQL Server 2022 Part 2
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This […]
SQL WHERE Tutorial
The post SQL WHERE Tutorial appeared first on SQLServerCentral.
Understanding the System Function FILEPROPERTY()
The SQL Server system function, FILEPROPERTY(), is used to retrieve database file properties. I will show you use […]
SQL WAITFOR Command to Delay SQL Code Execution
The post SQL WAITFOR Command to Delay SQL Code Execution appeared first on SQLServerCentral.
Manage Your Business Rules in T-SQL Query
Motivation At some point in the carrier, we have come across the problem of hard-coded values in SELECT […]
T-SQL Language Changes in SQL Server 2022
SQL Server 2022 is in preview in August 2022. I assume this version will be released later this […]
Understanding the Metadata Function DATABASEPROPERTYEX()
SQL Server offers various metadata functions to return metadata information about databases and its objects. Today, I will […]
INSERT EXEC statement cannot be nested, the Simple Solution
If you use the tSQLt unit testing framework for long enough, you will eventually run into the “An […]
Create a Table in Microsoft SQL Server
The post Create a Table in Microsoft SQL Server appeared first on SQLServerCentral.
[Video] Fundamentals of Stored Procedures at SQLBits
Anybody can write a stored procedure with a little help from Google. This session is about how to […]
Generate Random Dates in T-SQL
The post Generate Random Dates in T-SQL appeared first on SQLServerCentral.
T-SQL Comment Best Practices for SQL Server
The post T-SQL Comment Best Practices for SQL Server appeared first on SQLServerCentral.