Solutions To Real World Problems

Lesson 45. Listing All Tables In A SQL Server Database

Lesson 46. Listing All Columns In A SQL Server Database

Lesson 47. Pull Records From A Table At Random

Lesson 48. A Better Alternative To WITH (NOLOCK)

Lesson 49. Boost Performance When Calling A Stored Proc From SSIS

Lesson 50. Setting Up Queries For Ablation Testing

Lesson 51. Reduce Code And Save Time With Default Column Values

Lesson 52. Finding Duplicate Records In A Table

Lesson 53. Why You Cannot Have More Than One Clustered Index On A Table

Lesson 54. Converting Dates To YYYYMMDD

Lesson 55. Sending Notification Emails With T-SQL Without Using Hardcoded Email Addresses

Lesson 56. Troubleshooting Long Running Queries

Lesson 57. Loading Large CSVs Into Data Warehouse Staging Tables

Lesson 58. The Only Bloody Good Reason To Use Cursors

Lesson 59. Loading A Type II Slowly Changing Dimension With SQL Merge

Lesson 60. A Clearer Explanation Of The Parameters Of The Numeric Data Type

Lesson 61. Why You Cannot Join On Null Values

Lesson 62. A Deep Dive On How The Where Clause Functions

Lesson 63. Using HASHBYTES() To Compare Character Strings

Lesson 64. Using Pipe To Hash Multiple Columns For Matching

Lesson 65. Why People That Indent Code Drive Me Nuts

Lesson 66. How To Rapidly Stand Up A Data Warehouse From Scratch

Lesson 67. How To Pivot Data With T-SQL When Columns Are Not Predefined

Lesson 68. Prepopulating A Junk Dimension