SQL

Empty Thoughts: Working with NULL

  • Article

Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.

2019-02-11

3,289 reads

Missing Data

  • Article

In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation.

2017-11-13

4,133 reads

SQL Code Smells

  • Article

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.

2017-11-06

8,928 reads

Six Scary SQL Surprises

  • Article

The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.

2017-10-31

7,099 reads

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

  • Article

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.

2017-08-25

5,735 reads

Blogs

Microsoft Ignite Announcements 2021

By

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

Daily Coping 4 Mar 2021

By

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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Read the latest Blogs

Forums

combine two interval tables into single result set

By rbroersma

Hello, Looking for help combining two interval tables together.  The tables are pretty simple......

How can do a loop select stmt from this folowing table

By aggy_02_20

Hi..How can do a loop statement for the following table first loop shld be...

Azure SQL Managed Instance Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Managed Instance Features

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers