Technical Article

Date Time Range or Calendar Generator

This function returns a formated calendar table. It came in handy a few times for me, so I thought it may be a good contribution. There would be a few better ways to create this function if date-part were a valid data type. It is a pretty straight-forward function. You may edit it if you […]

You rated this post out of 5. Change rating

2006-10-05 (first published: )

418 reads

Blogs

A Very Cool Benefit in SSMS 21

By

I saw a post from Erin that Preview 2 is available. I’d gotten a...

AI Helping with an API

By

Can an AI help me with some database API work? Let’s see. This is...

Creating a “Real” Copy of a View: #SQLNewBlogger

By

I saw a post where a developer was trying to read the Information Schema...

Read the latest Blogs

Forums

Getting blockage on Update Statement

By anshu.shikha

Hi, Need your help. I've a SP that is using Update statement on a...

Query is filling Tempdb

By Nita Reddy

I have query which is filling TEMPDB I need suggestion how to modify this...

Script is filling Tempdb

By Nita Reddy

I have query which is filling TEMPDB I need suggestion how to modify this...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers