Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
34,778 reads
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
34,778 reads
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-25
1,118 reads
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-02-04
3,941 reads
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-21
2,926 reads
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers