Dates

SQLServerCentral Article

How to Find the Start and End Dates for the Current Week (and more)

  • Article

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.9 (10)

You rated this post out of 5. Change rating

2022-07-13

28,523 reads

Blogs

Playing with the Data API Builder

By

I published an article today on the Data API Builder, which is a way...

A New Word: Dolonia

By

dolonia – n. a state of unease prompted by people who seem to like...

Cloudbrew 2024 – Slides

By

You can find the slides for the session Building the €100 data warehouse with...

Read the latest Blogs

Forums

Understanding allowed topics for testing

By avishwan

Hi, I am a first time writer looking to author some content here. I...

Do As I Say, Not As I Do

By Grant Fritchey

Comments posted to this topic are about the item Do As I Say, Not...

Filter a SQL Server Audit with a predicate

By michal.lisinski

Hi Gents, Silly question, but it's been a long time since I've done this....

Visit the forum

Question of the Day

The New Log File

I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code: 

USE [master]
GO
CREATE DATABASE [TDE_Primer] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' )
 FOR ATTACH_REBUILD_LOG
GO
How big is the new log file?

See possible answers