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
435 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
340 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
430 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
183 reads
Blogs
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
how to list index corresponding to statistics using select statement
Hi , with query bellow I can list DTA statistic that is not updated...
Get files based on SQL results
I have a sql task which queries a database and returns a result set...
Ask SSC