Get Number of Days in month

Have seen existing scripts to work out number of days in month. They tend to work out the month, and then whether it's a leap year.Another approach is to take the date passed in, find the first day of the next month, and then use Datadd to take off one day, ie: last day of […]

4 (1)

2002-10-17

394 reads

Blogs

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Steps for a Successful Data Migration Session at Microsoft Ignite

By

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Using mode() in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using mode() in R

Machine Learning Services on Database Server verses R Lang Execution on Laptop

By HookSQLDBA7

We are running SQL Server 2017 (RTM) on Windows. The question came up, if...

Stored Procedure "Caching"

By LightVader

I'm having an issue with a database that I recently moved from SQL 2014...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers