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

Content with tags Data Warehousing, Database Design Rss

   Items 1 to 4 of 4   

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 720 reads

An Interview with Ralph Kimball

Ralph Kimball, founder of The Kimbaal Group, shares some thoughts on data with PASS.   Read more...
By Additional Articles 2004/11/08 | Source: PASS | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,429 reads

Normalizing Dates

Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!   Read more...
By Jon Winer 2003/09/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,179 reads

Designing a Database with Microsoft Visio 2000

An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.   Read more...
By Bruce Szabo 2002/07/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 8,961 reads
   Items 1 to 4 of 4   
miscellaneous (3)    
advanced (1)    
basics (1)    
design and theory (1)    
development (1)    
other (1)    
product reviews (1)    
programming (1)    
reviews (1)    
sql server (1)    
sql server 2012 (1)    
sql server 2016 (1)    
t-sql (1)