Last week we were running contest Identify the Database Celebrity and we had received a fantastic response to the contest.
SQL SERVER – Select Columns from Stored Procedure Resultset
It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the…
Read More
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
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.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3
Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? and SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2. In part 2 of the blog post, I wanted to write…
Read MoreSQL Contest – Hint for Identify the Database Celebrity
Earlier week I have posted a SQL Contest about Identifing the Database Celebrity over here Identify the Database Celebrity – Win USD 100 Amazon Gift Card. We have got fantastic response to the blog post however, there are quite many readers have requested Hint to the contest. In the world…
Read MoreSQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2
Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?. Right after the blog post was published I received an email from SQL Server users who have no access to CTE and wanted me to help him out…
Read MoreSQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?
The first email I read this morning had only one statement in it, and it gave me an idea to write this blog post. “How to access Previous Row Value and Next Row Value in SELECT statement?” Very interesting question indeed. The matter of the fact, I have written about this…
Read More
SQL SERVER – UDF, UPDATE and More – Memory Lane – #047
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.
Developer – Best Practices for Daily Stand-Up or Daily Scrum – Rules and Regulations
Scrum is an Agile Software Development framework that helps teams complete projects efficiently while maintaining high quality.
SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card
Regular readers of this blog are familiar with NuoDB and their generous offers for SQLAuthority.com readers. I was just talking to them earlier and together we have come up with a very interesting contest for all of us. This contest has two parts. Part 1 Identify Database Personality and in Part…
Read More