SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
620 reads
T-SQL
2023-11-27
3,031 reads
Efficient Table Migration to a New Schema in T-SQL
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2023-11-03
1,998 reads
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
2023-09-18
3,283 reads
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
2023-08-28
Sample Use Case for Using SQLCMD Utility Batch Files
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
2023-07-14
Starter Metadata T-SQL Query Examples for Databases and Tables
SQL Server provides lots of information about various aspects of server and database objects and this data is referred to as metadata. Understanding what is available and how to use this metadata can greatly enhance and streamline how you can work with SQL Server.
2023-07-07
Paging Data in T-SQL
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
2023-06-28
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
2023-05-19
Find 40 Problems in this SQL Server Stored Procedure
I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.
2023-05-10
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Breaking Biometrics
Comments posted to this topic are about the item Breaking Biometrics
Attaching Databases
Comments posted to this topic are about the item Attaching Databases
Ask SSC