SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Wagner Crivelini

SQLServerCentral.com profile

   Items 1 to 4 of 4   

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.   Read more...
By Wagner Crivelini 2010/10/25 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 13,057 reads

SQL and the JOIN Operator

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: |  Discuss |   Briefcase | 45,240 reads

Database Modeling and Diagrams with SQL Server 2008

How to use Database Diagram tool in SQL SERVER.  Read more...
By Wagner Crivelini 2009/05/19 | Source: SQLServerCentral.com | Category: diagrams
Rating: |  Discuss |   Briefcase | 10,782 reads

Cursors for T-SQL Beginners

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: |  Discuss |   Briefcase | 22,301 reads
   Items 1 to 4 of 4