Jen McCown


Blog Post

Fun with Operator Precedence

Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...

2016-01-06 (first published: )

2,824 reads

Blogs

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

By

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By

Here is another short video (~ 15 minutes). This is by the author of...

Read the latest Blogs

Forums

Managed Instance vs Azure Database - is this a good option?

By jasona.work

We're currently in Azure, however as we had a very tight migration timeline when...

MERGE in a nested TRY/CATCH won't roll back

By Pete Bishop

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers