June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

Interview Question of the Week #044 – What is the difference of performance between SELECT and SET?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Scripts
Question: What is the difference of performance between SELECT and SET? Answer: SELECT : Designed to return data. SET : Designed to assign values to local variables. While testing the performance of the following two scripts in query analyzer, interesting results are discovered. SET @foo1 = 1; SET @foo2 =…
Read More
All Articles 101-1-600x400

SQL SERVER – What is the OVER Clause? – Notes from the Field #101

Pinal Dave
SQL
Notes from the Field, SQL Function, SQL Scripts, SQL Server

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Over clause. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has instigated love for this technology in me. Today she brings a relatively interesting topic for database experts. Read the experience of Kathi in her own words.

Read More