June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL Documentation, SQL Download, SQLAuthority Author Visit, SQLAuthority Book Review
Earlier month I released by third book SQL Server Interview Question and Answers. The focus of this book is ‘master the basics’. If you rate yourself 10 out of 10 in SQL Server – this book is not for you but if you want to learn fundamentals or want to…
Read More

SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SafePeak, the unique automated SQL performance acceleration and performance tuning software vendor, announced the winners of their SQL Performance Contest 2011. The contest quite unique: the writer of the best / most interesting and most community liked “performance story” would win an expensive gadget. The judges were the community DBAs…
Read More

SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
Earlier I wrote a series on SQL Server Analytic Functions of SQL Server 2012. During the series to keep the learning maximum and having fun, we had few puzzles. One of the puzzle was simulating LEAD() and LAG() without using SQL Server 2012 Analytic Function. Please read the puzzle here…
Read More