SQL RNNR

Blog Post

December Recap

The past few months I have been pretty busy.  December is no exception to that.  Between normal work, moonlighting as...

2011-12-29

1,518 reads

Blog Post

December Recap

The past few months I have been pretty busy.  December is no exception to that.  Between normal work, moonlighting as a general contractor on my own basement, and trying...

2011-12-29

Blog Post

My Top 5 for 2011

I have seen a few recap posts bouncing around the net and started thinking about my own blog.  So out of curiosity, I decided to take a look at...

2011-12-28

Blog Post

Filtering in SSMS

Do you spend seconds, maybe even minutes trying to find things in SSMS?  Ever find yourself scrolling up and down thrown the tree trying to find that one specific...

2011-12-21

7 reads

Blog Post

Why do I Blog?

Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily.  This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....

2011-12-17

Blogs

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4

By

One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...

Read the latest Blogs

Forums

SQL Server 2025 Jobs

By Do

Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...

how to optimise whole database full of table and sp in one go using githubcopilo

By rajemessage 14195

i have subscription of github copilot which i can access in vs 2022 comunity...

Password Guidance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Guidance

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