Skip to content
tsql.nu

tsql.nu

Magnus Ahlkvist of Transmokopter SQL AB

  • Home
  • About me
  • Presentations
    • Eight hours of work in 20 minutes – partitioning rocks
    • My romantic relation with Powershell generally and Dbatools especially.
    • RBAR BAD. SETS GOOD.
  • Transmokopter
  • SQL Friday

Tag: NULL

Posted on 8 November, 201631 October, 2019

What is NULL?

If you ever studied normalisation of databases, you have probably come to the same conclusion as I have regarding NULL: It is best if NULL values in the database can be avoided but it is not always easy to achieve a NULL-free database. Let’s look at an example:

Continue reading “What is NULL?”

Data Platform MVP

SQL Friday

It's SQL Friday
Tweets by Transmokopter

Recent Posts

  • Dapper Parameters – Explicit Content
  • Begin automatic row versioning on an existing table (Temporal Tables part 2)
  • Temporal Tables for Row Versioning with Transact-SQL (part 1)
  • Video: T-SQL to Generate Time Slots. FAST, with a Tally Table
  • Video and Stored Procedure: Generate N-length codes with T-SQL and a Tally Table

Archives

  • December 2022
  • December 2021
  • November 2021
  • September 2021
  • December 2020
  • September 2020
  • July 2020
  • May 2020
  • April 2020
  • November 2019
  • October 2019
  • December 2017
  • February 2017
  • November 2016
  • April 2016
  • November 2015
  • October 2015
  • September 2015
  • July 2015

Categories

  • Performance tuning
  • SQL Family
  • SQL Server Replication
  • Stupid errors I forget the solution to without writing them down
  • T-SQL code
  • Training and conferences
  • Uncategorized

Tags

  • Cardinality estimation
  • Data Quality Client
  • Data Quality Services
  • DataWeekender
  • DBCC CLONEDATABASE
  • DBCC SHOW_STATISTICS
  • DQL
  • execution plans
  • indexes
  • index maintenance
  • NULL
  • performance
  • query hints
  • SqlFamily
  • SQLPass
  • SQLSaturday
  • SQL Training
  • statistics
  • t-sql

Kontakt

magnus@transmokopter.se
+46 70 536 65 67

Microsoft Certified Trainer Microsoft Certified Solutions Expert Data Platform

Proudly powered by WordPress