Cursors for T-SQL Beginners
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
22,342 reads
Wagner Crivelini
SQL and the JOIN Operator
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-02-25 (first published: 2009-10-07)
45,305 reads
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,078 reads
2009-05-19
11,062 reads
Blogs
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Transforming rows into columns
Hi Everyone, I have a table with the structure as attached in the Table...
Reduce SQL Filestream limit
I want to save images into an sql database, and in my situation the...
Ask SSC