How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
2,655 reads
DateFirst
2022-05-27
462 reads
2020-06-15
562 reads
Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
527 reads
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
9,948 reads
Blogs
The book that made me love goal-setting
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
Daily Coping 16 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Server Query Tuning and Optimization by Benjamin Nevarez
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...
Forums
how to create index rebuild job on SQL Pas machine
how to create index rebuild job and stats jobs on SQL Pas machine can...
How to use PowerShell to set secure SA passwords for bulk servers
Comments posted to this topic are about the item How to use PowerShell to...
Substitute 0 and 1 values in 1 column
Hello everyone, Hi have this column named Sex and it only has value 0...
Ask SSC