Language: SQL||Expertise: Advanced
Set-based solutions are always faster than loops in SQL, right? Usually that is true but not always. You should generally take a set-based solution first, performance test it (at scale!) and start investigating loops only if you find your set-based approach, for some reason, fails to scale up.
Language: SQL||Expertise: Intermediate
A very quick way to import data from Excel into SQL Server.
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
Tech Ed 2008—Unifying Everything