Performance

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

6,998 reads

External Article

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  • Article

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.

2018-06-26

2,974 reads

Blogs

SQL Server Time Bombs

By

Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...

Book Review: A Radical Enterprise

By

I grabbed this book over the 2024 holiday season as it was on sale...

Advice I Like: Investing and Growing Rich

By

Investing small amounts of money over a long time works miracles, but no one...

Read the latest Blogs

Forums

Dateadd with a numeric value

By MMartin1

Comments posted to this topic are about the item Dateadd with a numeric value

A Poor Data Model

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Poor Data Model

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

By Abhinay Malipeddi

Comments posted to this topic are about the item Determining Whether Home Addresses Fall...

Visit the forum

Question of the Day

Dateadd with a numeric value

What is returned from the following query ?

declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000'

select  dateadd(hour, 3.0/2, @currentDateTime);

See possible answers