Bert Wagner

Blog Post

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: )

802 reads

Blog Post

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: )

471 reads

Blog Post

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 identity columns...

2019-06-25

4 reads

Blog Post

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 identity columns...

2019-06-25

6 reads

Blog Post

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: )

1,001 reads

Blogs

A New Word: Lilo

By

lilo– n. a friendship that can lie dormant for years only to pick right...

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Read the latest Blogs

Forums

Database Archive missing FK

By abdalah.mehdoini

Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger...

SQL Server 2005 service fails to start

By iluminadajung

Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...

How to Repair Corrupt MySQL Tables

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Repair Corrupt MySQL...

Visit the forum

Question of the Day

The Funny Dynamic SQL

What happens when I run this code:

EXEC sp_executesql N'PRINT 1; GO';

See possible answers