Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Missing Date Ranges- the Sequel
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Many Uses of Coalesce in SQL Server
Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.
Congratulations to Our New MVPs
Two longtime members of the SQLServerCentral.com community received the well-deserved MVP status this week. Congratulate Jeff Moden and Michael Coles.
Recursive Queries using Common Table Expressions (CTE) in SQL Server
The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?
Slowly Changing Dimension in SQL Server 2005 – Part 2
This article is Part 2 in the series which explores the options available in SQL Server 2005 for Slowly Changing Dimensions
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers