Mee too...
Thanks & Regards
Piyush Dhangar
NIIT LTD, 85, Sec. 32, Gurgaon 122001
Ph: +91-124-4293241
-----Original Message-----
From: Godar Rose
[mailto:mssqldba-ezmlmshield-x21051207.[Email address protected]
Sent: Wednesday, September 27, 2006 10:57 PM
To: LazyDBA Discussion
Subject: RE: Design question
I would definitely go with a secondary table.
-----Original Message-----
From: Carol Green
[mailto:mssqldba-ezmlmshield-x70369394.[Email address protected]
Sent: Tuesday, September 26, 2006 10:57 AM
To: LazyDBA Discussion
Subject: Design question
Hello all,
a design question for you:
We currently have a table which is accessed by several different
applications. However, we have been asked to add several huge varchar
columns to hold a bunch of text (a crap idea if you ask me). The varchar
fields will be completed for most but not all of the records. These
fields are only relevant to two of the applications.
Would it be better to have one main table or to have two tables, one for
the basic data and one for all the guff?
I'm thinking two tables although I wasn't sure how much of a performance
issue it would be to have the varchar fields in the same table as the
frequently accessed fields.
Carol.
This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within
it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the
information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment
on the part of Optilan unless confirmed by a communication signed on behalf
of the company.
Any email cannot be guaranteed to be secure, error free or free from
viruses. Although every possible care is taken by Optilan, Optilan does not
accept any liability whatsoever for any loss or damage which may be caused
as a result of the transmission of this message by email.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are solely for the use of the individual or entity to which it is addressed. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of the company shall be understood to be neither given nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this email, when addressed to Clients is subject to the terms and conditions in governing client contract.
MS Sql Server LazyDBA home page