David Poole

An Is Null Gotcha

In T-SQL you should use the IS NULL keywords to test for a null value. But David Poole runs into a strange gotcha in one of his applications where he is testing for a null value. It's an interesting read following Sherlock Poole around on his hunt to find an error.

4.75 (4)

2004-07-14

11,690 reads

Using Bits to Store Data

David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.

5 (1)

2004-01-06

6,390 reads

Dealing with Addresses

David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!

5 (3)

2003-07-01

9,728 reads

Blogs

Running Express Edition in a Container–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

How SQL Server stores data types: sql_variant

By

This post looks at a curious data type that isn’t really a data type....

Microsoft Ignite Announcements 2020

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs

Forums

DBA progress/career development/ path

By anoop.mig29

Hi I am an post-grad and mssql server dba with around 5/6 years of...

Why is the topic I'm trying to start not posting?

By DHL-John.Parker

I have a very challenging issue with integrating a CLR on a new MSSQL17...

sql server laptops using AMD processor

By anoop.mig29

Hi I have current dell laptop with intel processor .I has become old and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers