2020-02-27
14,901 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)
4,910 reads
Blogs
2020 Advent of Code – Day 5
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
What’s new with Power BI?
By James-Serra
At the Microsoft Business Applications Summit 2021, a ton of new features for Power...
Forums
Availability Group with Replication
I have configured availability group for automatic failover with synchronous mode. So that way...
Geocoding in SQL Server - do I need C# for it?
I've been digging around playing with spatial maps in SQL Server. I've read a...
Ask SSC