SQL

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

Last Week Reading (2020-08-02)

By

Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from...

Online certification exams are definitely different

By

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams...

Office Upgrade – A Secret Lab Chair

By

Last year I wandered over to Glenn Berry’s house for some lunch and a...

Read the latest Blogs

Forums

Offline Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Offline Files

Confidential VMs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Confidential VMs

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

By iLearnSQL

Comments posted to this topic are about the item Change the Instance Collation by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Offline Files

See possible answers