When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.
2011-02-15
5,434 reads
This article demonstrates the relative merits of natural and surrogate keys and benchmarks their performance in different scenarios.
2011-01-10
4,502 reads
Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.
2009-09-08
7,199 reads
2003-08-28
5 reads
Is this what you want declare @max int declare @ct int declare @sql nvarchar(4000) select @max = max(ColPosition) from frtabledef where jobid = @jobid create table #newtable (Jobid int) set @ct=0 while (@ct < @max) begin set @ct=@ct+1 set @sql = 'alter table #newtable add Col'+ cast(@ct as varchar)+ ' varchar(20) null' exec sp_executesql @sql […]
2003-07-25
what is the package trying to accomplish? I run into similar problem when trying to call a oracle script using sql+ from DTS package. I forgot 'exit' command on the script.
2003-06-21
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers