Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Wagner Crivelini 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: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 13,042 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 45,202 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: | Category: diagrams
Rating: |  Discuss |   Briefcase | 10,717 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: | Category: cursors
Rating: |  Discuss |   Briefcase | 22,272 reads
   Items 1 to 4 of 4