Another Number of Days in Month Function
Here is another Number of Days in the Month function for SQL Server without the use of Case or if statements. It uses the DATEPART and DATEADD built-in functions.
2002-10-28
407 reads
Blogs
Markdown Links– Remembering the Basics
By Steve Jones
For some reason, I can never remember how to do markdown links. I know...
Why Aren’t You Automating Database Deployments?
Building out processes and mechanisms for automated code deployments and testing can be quite...
Daily Coping 23 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Query performance with ROW_NUMBER function
Hello All, Could any of you please let me know why the row_number paging...
multisubnet configuration
Good morning all , I am in an alwayson multisubnet configuration, the listen and...
Simple Recovery Model - Active VLFs cannot be truncated
Hi everyone, I am facing a strange situation. I've got 99% of VLFs active...
Ask SSC