Performance and Tuning

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

4,837 reads

Technical Article

Plansplaining, part 20. SQL Graph (part 1)

  • Article

Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.

2023-12-06

Blogs

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

What I actually do at Microsoft

By

I started working at Microsoft in January 2022. I enjoy it. I even wrote...

Talkie - a simple, private, responsive interface for LLMs

By

Watch this video on YouTube I like using ChatGPT. But I don't like the $20/month...

Read the latest Blogs

Forums

What happened to my SSMS shortcuts in 20.1?

By Eric Mamet

I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E...

logshipping is out of synch need to debug

By anoop.mig29

Hi We have logshipping which get out of synch in night due to purging...

large transaction log backups

By vsamantha35

Hi All. From last 4-5 days we are seeing log backup file sizes increased...

Visit the forum

Question of the Day

Operator Precedence Order

What is the correct order of operator precedence from highest (evaluated first) to lowest?

See possible answers