Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
9,148 reads
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
9,148 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
8,565 reads
2019-10-28
6,177 reads
Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
4,877 reads
A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.
2015-03-18
2,786 reads
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-28 (first published: 2008-03-07)
6,622 reads
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
IV therapy is also good for your heart. Certain amino acids relax the blood...
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Hi all, I am running the following query in SQL, trying to export some...