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)

You rated this post out of 5. Change rating

2015-10-23 (first published: )

29,524 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 […]

You rated this post out of 5. Change rating

2004-08-19

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 […]

You rated this post out of 5. Change rating

2004-03-09

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers