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
450 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
343 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
434 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
188 reads
Blogs
Copying large files from SharePoint Online
I recently worked on a project where we needed to copy some large files...
How Long has Your SQL Server Been Online
By gbargsley
This week’s blog post will help you check your SQL Servers up-time. There are...
The less you hear from or about the DBAs the better they are doing their job.
Something I’ve been thinking about recently is that DBAs are best when they are...
Forums
Ordering String_Split()
Comments posted to this topic are about the item Ordering String_Split()
Worse Before Better
Comments posted to this topic are about the item Worse Before Better
Azure SQL Managed Backup for on-prem databases
I have a SQL 2017 on-prem database server that the client wants to back...
Ask SSC