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
449 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
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Disabling all access to the server
Hello everyone! We have a small group of users (4) using MS Access 2000...
How to remove data and index fragmentation in a table
The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...
Database Recovery but DB is 7GB and log file is almost 3
I have had a server crash and although I was able to recover the...
Ask SSC