Day of Week
To find the day of week, regardless of-SET DATEFIRST -SET DATEFORMAT -SET LANGUAGEThe first one is based on Zellers Congruence.The second one is a SQL server proprietary.
2002-04-05
439 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
341 reads
Today with no time portion
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
432 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
185 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Extended Events
I have set up an extended event to capture the queries users may be...
Script logins and all permissions: no longer supported in SSMS generate script?
Okay, maybe I've just gone crazy but I was certain it used to be...
Recursive Select runs slow
Hello, I have a recursive Select that runs ultra slow. My test table has...
Ask SSC