SQL RNNR

Blog Post

May I help you?

With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games.  Those were the greatest winter...

2010-02-18

817 reads

Blog Post

DBA.Sleep(8hrs)

I have been pondering recently what helps me to sleep at night.  Or, conversely, what prevents me from sleeping at...

2010-02-17

1,312 reads

Blog Post

In Vs. Inner Join

This is tightly related to another of my forays into tuning some slowly/poorly performing processes.  This process came across my...

2010-02-16

866 reads

Blog Post

PayPeriod II

I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...

2010-02-14

787 reads

Blog Post

Relationships

This month Rob Farley is hosting TSQL-Tuesday #3.  The topic is Relationships and he has left it wide open for...

2010-02-09

869 reads

Blog Post

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:

T-SQL Tuesday Participation Over the Years December 19, 2018

T-SQL Tuesday #104: Just Can't Cut That Cord...

2010-02-02

3 reads

Blogs

Using SQLFluff

By

I thought I didn’t care about linting, and lately, I haven’t written a lot...

Marketing Analyst: The Data-Driven Superhero Your Company Needs

By

Want to blend your love of marketing with the power of data? Becoming a...

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Lower Your Attack Surface Area

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lower Your Attack Surface Area

Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions

By Noman072

Comments posted to this topic are about the item Understanding SQL Server LEFT_SHIFT and...

Visit the forum

Question of the Day

A Strange Choice

What is returned when I run this code in SQL Server 2022?

CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci

See possible answers