Bert Wagner

SELECT Expression Execution Order

Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...

2019-07-23 (first published: )

779 reads

Multiple Identity Inserts

Watch this week’s video on YouTube. This week I want to share something that surprised me about using SQL Server’s SET IDENTITY_INSERT statement. I started with two tables with...

2019-07-10 (first published: )

410 reads

Trailing Spaces in SQL Server

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

2019-07-03 (first published: )

536 reads

Joker’s Wild

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-25 (first published: )

436 reads

CHOOSE() in SQL Server

Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...

2019-06-04

285 reads

IN vs UNION ALL

Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...

2019-05-13 (first published: )

1,191 reads

Blogs

Fun Fact: AWS RDS and system_health

By

Did you know that the system_health Extended Event session was running in your RDS...

Daily Coping 2 Jun 2020

By

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

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

By

How about for this months TSQL Tuesday let’s do another month of tips and...

Read the latest Blogs

Forums

Buying Pancrelipase without a script, Pancrelipase bottle

By stanley

Buying Pancrelipase without a script, Pancrelipase bottle We always do our best to satisfy...

Buy Protopic substitute canada, Protopic zalf ingredienten

By stanley

Buy Protopic substitute canada, Protopic zalf ingredienten ORDER NOW! Get a giant discount and...

Buy Azathioprine online without dr approval, Azathioprine and siadh

By stanley

Buy Azathioprine online without dr approval, Azathioprine and siadh Only this month we offer...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers