SQL Swimmer

Blog Post

Speaking at SQLBits

I got an early Christmas present this year, I found out I had been selected to speak at SQLBits!  That’s what I call a gift that keeps on giving....

2019-01-04

6 reads

Blog Post

Where to Store Index DDL

Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that had multiple clients with varied usage patterns.  You can...

2018-11-23

4 reads

Blogs

Modify Power BI page visibility and active status with Semantic Link Labs

By

Setting page visibility and the active page are often overlooked last steps when publishing...

T-SQL Tuesday #190–Mastering a New Technical Skill

By

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...

Getting Started with the MSSQL AI Agent in VS Code

By

Recently I was working in VS Code and I saw a walkthrough for the...

Read the latest Blogs

Forums

Laptop on Rent in Bangalore – Flexible & Affordable Solutions

By SRITTECH

Looking for a laptop on rent in Bangalore? Renting laptops is a smart choice...

Password Guidance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Guidance

Using table variables in T-SQL

By Alessandro Mortola

Comments posted to this topic are about the item Using table variables in T-SQL

Visit the forum

Question of the Day

Using table variables in T-SQL

What happens if you run the following code in SQL Server 2022+? 

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;
 

See possible answers