Date Calculations

SQLServerCentral Article

A Simple Formula to Calculate the ISO Week Number

  • Article

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!

4.89 (36)

2015-10-23 (first published: )

31,351 reads

Technical Article

RE: Transaction logs keep filling up

  • Reply

In FULL recovery mode, the transaction log will not make available the space until a full backup is performed, or a transaction log backup is performed at which point the inactive portion of the transaction log will be used.  The physical log size will not be returned to the OS until it is shrunk after […]


Technical Article

Data till transaction is commited

  • Topic

Hi All,II have a question on Transaction commit/rollback. Question My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles). For Example if i am doing a bulk copy of millions of records from a flat file on to sql server table, untill all the records are […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Being Agile - A Success Story

By Hemandu Malhotra

Comments posted to this topic are about the item Being Agile - A Success...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers