Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Table Operation

This is the fourth post in the series of finding previous row and next row value in SELECT Statement. Read all the blog post before continuing reading this blog post for complete idea.

In the very first part I discussed that performance with the help of CTE is very poor and I encouraged users to use LEAD and LAG function of SQL Server 2012. My friend and SQL Server Expert Szymon Wojcik have written a fantastic post about this subject. I encourage everyone to read that blog post. He has demonstrated that with the help of numbers table, we can further improve the performance of the query.

Read More

SQL SERVER – UDF, UPDATE and More – Memory Lane – #047

Pinal Dave
SQL
Memory Lane, SQL Server

This is the 47th episode of Memory Lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite blog posts are about UDF and the difference between UPDATE and UPDATE (). Let me know which one of the following is your favorite article from memory lane.

Read More

SQL – Solution – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

Pinal Dave
SQL Puzzle
Blogging, SQL Server

Earlier this month we were running a contest for solving the crossword based on my Blogging courses – Course 1, Course 2. Here are the details of the contest. The winner of the contest was to win Melting Clock (Do not confuse this as a dummy or not working clock. This looks like melting, but it always shows accurate time and it is perfectly balanced to hang off of any flat surface). Let us see Crossword Puzzle.

Read More
memory lane

SQL SERVER – Online Index Operations, NEWID and More – Memory Lane #042

Pinal Dave
SQL Tips and Tricks
Memory Lane, SQL Index, SQL Server

This is the 42nd edition of Memory Lane weekly series. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite article is about Online Index Operations and NEWID. Let me know which one of the following is your favorite article from memory lane.

Read More

SQL SERVER – SQL Basics: SQL 2012 Certification Path – Day 10 of 10

Pinal Dave
SQL Tips and Tricks
Joes 2 Pros, SQL Book, SQL Server, SQLAuthority Book Review

This is the 10th post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information. Let us see SQL 2012 Certification Path.

You can get that in Paperback (USA) and Kindle (Worldwide).

In training hundreds of people over that last decade to get their Microsoft certification, to my surprise the biggest benefit you get is something else. The most common benefit my students tell me about is that they get invited to far more job openings after getting certified than they did before. When the stack or resumes gets sorted down, they need a proven reason to keep yours on the short list.

Read More