What is PERCENTILE_DISC? Like the CUME_DIST function introduced last week, PERCENTILE_DISC is a statistical function. It […]

What is CUME_DIST? Suppose you have a table with certain values and […]

What are LEAD and LAG? Last week you saw how you use FIRST_VALUE and LAST_VALUE to […]

What are FIRST_VALUE and LAST_VALUE? Like the ROW_NUMBER and RANK functions introduced in weeks 12 to […]

What is DROP IF EXISTS? You’ve seen it over and over again […]

What does SHOWPLAN mean? If you’ve ever wondered what SQL Server is […]

What are temporary objects? Basically SQL Server allows you to create temporary […]

Week 26: SEQUENCE What are SEQUENCEs? One of the most important SEQUENCEs we […]

What is IDENTITY? IDENTITY is a property for columns in a table. It […]

SELECT TOP 0 INTO Occasionally you may want to create an empty […]