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
429 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
182 reads
Blogs
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
CPU?Memory and IO bottleneck check
Which indices will show cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...
Ask SSC