2020-02-27
11,436 reads
DATEADD
Performance Surprises and Assumptions : DATEADD()
Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
2016-05-12
4,956 reads
Add and Subtract Dates using DATEADD in SQL Server
Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.
2011-10-14
3,998 reads
Last month Name and Year in a SSRS expression
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
3,524 reads
Blogs
Information Measurement with SQL Server, Part 4.9: The Bregman Divergence
By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...
Let’s Talk About The Cloud
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...
Daily Coping 29 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Daily Coping 29 May 2020
Today’s tip is today link your decisions and choices to your purpose in life....
Week Ending Thursday, can some one tweek my code?
What I have missed from this code? I'm trying to show the DateTimeRaised field...
The Matchbox Database
Comments posted to this topic are about the item The Matchbox Database, which is...
Ask SSC