SQLServerCentral - Guest Columnist: Wagner Crivelini

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios. Read more...

By Wagner Crivelini 2010/10/25 | Source: SQLServerCentral.com | Category: primary key (pk)

Rating:

|

Briefcase | 12,859 reads

How the JOIN operator works, the different types of JOINs and relevant information about joining tables. Read more...

By Wagner Crivelini 2011/02/25 (first published: 2009/10/07) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 44,782 reads

How to use Database Diagram tool in SQL SERVER. Read more...

By Wagner Crivelini 2009/05/19 | Source: SQLServerCentral.com | Category: diagrams

Rating:

|

Briefcase | 10,221 reads

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications. Read more...

By Wagner Crivelini 2011/05/27 (first published: 2009/01/01) | Source: SQLServerCentral.com | Category: cursors

Rating:

|

Briefcase | 21,792 reads