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

Recent Posts

  • Lock escalation and ROWLOCK
  • Securely pass pass column names to dynamically change result set from SP
  • Stream Teams meeting to YouTube
  • EXECUTE AS to test permissions
  • Clone a docker volume used by SQL container

Archives

  • March 2024
  • February 2024
  • August 2023
  • March 2023
  • 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