Using Recursion and Date Tables to Simplify Date Logic
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
2011-12-13
10,169 reads
David Beardsley
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Backup file size 3X after shrinking the log file?
Here's a head scratcher - I've not seen anything like this in 20+ years...
repeating block of records
I want to look for blocks of records repeating in a table. pattern...
Ask SSC