473,320 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Re: Best practice on nullability and default value

The decision about defaults, constraints and NULL-ability should be
made on the basis of a good data model and not like this. Trying to
patch up things after an upload is going to eventually fail. Think of
the old Ford Motors slogan: "The Quality goes in BEFORE the Name goes
on!"

Jul 14 '08 #1
2 2426
DL
On Jul 14, 11:06*am, --CELKO-- <jcelko...@earthlink.netwrote:
The decision about defaults, constraints and NULL-ability should be
made on the basis of a good data model and not like this. *Trying to
patch up things after an upload is going to eventually fail. *Think of
the old Ford Motors slogan: "The Quality goes in BEFORE the Name goes
on!"
Thank you all. Sorry, my initial posting was too sketchy, also I was
fairly new to the environment, less than two weeks, with a monstrous
'master' sql script exceeding 10,000 lines of schema creation, view
creation, sp creation, UDF creation and trigger creation etc. etc...
with very poor comments or minimal comments associating technicality
with business functions, separate documentation is more like user
manual than a real Design Document for a piece of software for the
medical community.

On all columns except key columns being nullable with default values,
my boss told me today because of replication requirement, I've little
knowledge of replication (tried once got people scared, wrongly
thought I might stealing data something...). What's your thought on
the replication thing?
Jul 15 '08 #2
DL (ta********@gmail.com) writes:
Thank you all. Sorry, my initial posting was too sketchy, also I was
fairly new to the environment, less than two weeks, with a monstrous
'master' sql script exceeding 10,000 lines of schema creation, view
creation, sp creation, UDF creation and trigger creation etc. etc...
Could benefit from being broken down in pieces...
On all columns except key columns being nullable with default values,
my boss told me today because of replication requirement, I've little
knowledge of replication (tried once got people scared, wrongly
thought I might stealing data something...). What's your thought on
the replication thing?
I have very little experience of replication, but the argumnent sounds funny
to me. You may want to ask the friendly people in
microsoft.sqlserver.public.replication to have this confirmed.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 15 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

131
by: Peter Foti | last post by:
Simple question... which is better to use for defining font sizes and why? px and em seem to be the leading candidates. I know what the general answer is going to be, but I'm hoping to ultimately...
136
by: Matt Kruse | last post by:
http://www.JavascriptToolbox.com/bestpractices/ I started writing this up as a guide for some people who were looking for general tips on how to do things the 'right way' with Javascript. Their...
1
by: JohnH. | last post by:
Hi, Is there a better (best practice) way to do this? I have developed a large set of ASP.NET applications in C#. Like most applications I have a set of utility pages that can be called by...
10
by: Ren | last post by:
Hi All, I'm still rather new at vb.net and would like to know the proper way to access private varibables in a class. Do I access the variable directly or do I use the public property? ...
5
by: csgraham74 | last post by:
Hi guys, Basically i have been developing in dotnet for a couple of years but ive had a few issues in regards to error handling. For example - I have a class that i call passing in a stored...
1
by: Muchach | last post by:
Hello, Ok so what I've got going on is a form that is populated by pulling info from database then using php do{} to create elements in form. I have a text box in each table row for the user to...
52
by: burgermeister01 | last post by:
First, let me say that this question is a rather general programming question, but the context is PHP, so I figured this group would have the most relevant insight. Anyways, this is also more of...
19
by: Daniel Pitts | last post by:
I have std::vector<Base *bases; I'd like to do something like: std::for_each(bases.begin(), bases.end(), operator delete); Is it possible without writing an adapter? Is there a better way? Is...
5
by: Frank Millman | last post by:
Hi all This is not strictly a Python question, but as I am writing in Python, and as I know there are some XML gurus on this list, I hope it is appropriate here. XML-schemas are used to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.