Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,006 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,019 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,514 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,080 reads
   Items 1 to 4 of 4