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,374 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,568 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,183 reads
2009-05-19
11,996 reads
Blogs
Daily Coping 9 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Webinar: How to unlock the value of frequent deployments
By Steve Jones
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...
SSMS 18.5 Fixes from Redgate
By Steve Jones
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...
Forums
ALWAYS On Setup problem
While configuring N1 and N2 Nodes connected to DC Domain Controller working fine. Establishing...
Do You Have a Mentor?
Comments posted to this topic are about the item Do You Have a Mentor?
Counting Rows in DAX
Comments posted to this topic are about the item Counting Rows in DAX
Ask SSC