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,534 reads
The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".
2023-08-07
12,009 reads
In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
2022-11-15 (first published: 2022-09-14)
24,861 reads
Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.
2022-09-05 (first published: 2008-05-07)
150,763 reads
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
19,014 reads
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
23,035 reads
An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.
2021-11-23 (first published: 2008-08-19)
124,236 reads
What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.
2021-05-28 (first published: 2019-09-03)
9,831 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
6,101 reads
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
2019-05-22 (first published: 2009-11-10)
46,508 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Dears, I was told that I cannot access delta files in SQL Server Managed...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers