Tutorials
Practical T-SQL
Search
⌃
K
Practical T-SQL Pocket Guide For Beginners
Preface
Language Basics
Advanced Topics
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
Powered By
GitBook
Lesson 66. How To Rapidly Stand Up A Data Warehouse From Scratch
How do you stand up a data warehouse quickly? You use the Mass Street Analytics ETL Framework of course.
Why You Need An ETL Framework
Download The Framework
Previous
Lesson 65. Why People That Indent Code Drive Me Nuts
Next
Lesson 67. How To Pivot Data With T-SQL When Columns Are Not Predefined
Last modified
1yr ago