Welcome to Ashutosh Nilkanth’s Blog on Life and Technology!
You can quickly checkout the blog’s “greatest hits“, or read a post from the archives.
Or you can continue reading the latest posts and articles below, and rate them by selecting a star rating to the right of each post.
Feel free to leave a comment or ask a question, and consider subscribing to the latest posts via RSS or e-mail. You can also follow me on Twitter. Thanks for visiting!
SET vs SELECT
Loading ...Here’s a TSQL optimization tip: it seems like a single SELECT statement is faster than multiple SET statements.
SET @foo1 = 0
SET @foo2 = 0
SET @foo3 = 0
…
is slower than one SELECT like:
SELECT @foo1 = 0, @foo2 = 0, @foo3 = 0
[via Jason Lautzenheiser]
Posted under Databases and DBAL, Linklog, Technology | Posted on Sat, 25th Sep 2004 10:28 am
Entries