PERCENTILE_DISC

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

CUME_DIST

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

LEAD and LAG

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

FIRST_VALUE und LAST_VALUE

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

DROP IF EXISTS

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

SHOWPLAN

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

Temporary Objects

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

Sequence

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

IDENTITY

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

SELECT TOP 0 INTO

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