THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL » Database Design   (RSS)
Showing page 2 of 2 (14 total posts)
  • Setting reporting database–what happens behind the scenes

    When you install reporting server, you have in general two options available – either you install the reporting server and configure its database at the same time, or install just reporting service and point it to an existing database later. We had recently opportunity to configure server to point to existing reporting database. We encountered a ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on November 28, 2010
  • DEFAULT constraints and sp_bindefault

    When you deal with old databases, with origins somewhere around second half of nineteen nineties, you can expect all kinds of oddities, like funny naming conventions, (lack of) referential integrity, absence of clustered indexes and things like rules and defaults created separately from tables DDL. I just happen to work with such database. I see ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 20, 2010
  • Partitioned views

    I must say I am a big fan of views. They give flexibility of changing the logic of the data retrieval without affecting DAL layers in your application. I posted series of articles about updateable views and triggers on views, their application in SSIS for example. Recently we finished development of system that loads data from several external ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 10, 2010
  • Constructive versus Deconstructive

    I have been struggling to find a way to describe the fundamentals of first normal form for my PASS presentation, and this came to mind last night.  SQL works in a very constructive way, meaning that if you have base values (commonly referred to as atomic, or scalar values) then you can build up the view that you want.  However, have ...
    Posted to Louis Davidson (Weblog) by drsql on October 18, 2006
Privacy Statement