<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
DWH
Items 1 to 3 of 3
SCD Implementation with TSQL
ETL for a SCD using only TSQL, without hash functions
Read more...
By
Federico Iori
2012/11/13
|
Source:
SQLServerCentral.com
|
Category:
scd
Rating:
|
Discuss
|
Briefcase
|
873 reads
Insert new values in dimension avoiding deadlock
TSQL code deadlock-safe for inserting new value into dimension
Read more...
By
Federico Iori
2012/02/03
|
Source:
SQLServerCentral.com
|
Category:
dwh
Rating:
|
Discuss
|
Briefcase
|
1,108 reads
Enforcing surrogate key uniqueness in slowly changing dimension
Enforcing surrogate key uniqueness regards natural key in slowly changing dimension
Read more...
By
Federico Iori
2012/01/03
|
Source:
SQLServerCentral.com
|
Category:
dwh
Rating:
|
Discuss
|
Briefcase
|
597 reads
Items 1 to 3 of 3
Tags
dimension
(2)
scd
(2)
deadlock
(1)
exclusive table lock
(1)
indexed views
(1)
natural key
(1)
normalization
(1)
slowly changing dimension
(1)
surrogate key
(1)
tablockx
(1)
t-sql
(1)
without ssis
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
