This script shows the way, how to remove a time from datetimes.Do not move this code to UDF, it would run at least 6 times slower.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2003-04-03

73 reads

Blogs

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

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

Read the latest Blogs

Forums

Hi all We've got a linked server from SQL 2016 to an accdb...

Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...

Comments posted to this topic are about the item Understanding the Internals of a...

Visit the forum

See possible answers