A Faster BETWEEN Dates
This article shows us a different way of finding all records between 2 dates.
2010-11-01
29,263 reads
Terry Steadman
Creating Holidays and Special Dates
A way to save holiday records that can be created as needed into a search-able calendar table.
2010-08-04
12,308 reads
Blogs
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Daily Coping 30 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Server on Linux Storage Secrets on Microsoft Channel 9
By kleegeek
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...
Forums
Having sum(amount) = 0 returns negatives as well.
Hello all, I'm trying to get a list of ID's that have a total...
How to limit SQL Job Success events
Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...
SQL Server Agent producing unreproducible error
I've built a Powershell script, which I want to run through SQL Server Agent....
Ask SSC