2020-02-27
21,375 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)
7,847 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
CXConsumer wait type issue
hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...
How to speed up this?
Hi everyone One of my SSIS components seem to be very slow. I am...
Managing some particular dimensions in a data warehouse based on medical records
Hi, I need to design a data warehouse solution to manage medical records about...
Ask SSC