Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,601 through 48,615 (of 59,099 total)

RE: Documenting a Database

Start with using Visio to reverse engineer a diagram of the database... hopefully, they actually used Foreign Keys...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 12:42 pm

#863325
RE: Data File Growth

Hi Jim,
Indexes also count towards the size of the mdf. If you have wide indexes and a clustered index along with "fk" indexes, the size of your indexes can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 12:39 pm

#863323
RE: SQL 2000 Concatenate text fields within a view

Even if you concatenate and convert to text using something like...
[font="Courier New"]SELECT CAST('1'+'2'+'3' AS TEXT)[/font]
...you still won't be able to see more than 8192 characters in a single column, view...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 9:53 am

#863241
RE: Handling The Text Data Type

Robert...
I know it's been over a year since this article came out, but want to say what an outstanding article you've written... very easy to read and great examples!...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 9:42 am

#863232
RE: CdoNtsMail - What are the actual size limits to the "Body"

Update: I've found that the underlying code in the DLL uses the STRING data type for the things that take string data... in C#, that holds 2 billion bytes...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 7:45 am

#863124
RE: CdoNtsMail - What are the actual size limits to the "Body"

ps... I've found the following URL and I'm in the process of reading all the links contained in it...
http://support.microsoft.com/kb/312839
Even if you don't have a better place to look, I sure...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2008 at 7:12 am

#863098
RE: No: of day between two dates

So take one of the solutions already given and use it as a derived table in and aggregate query.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 11:38 pm

#862907
RE: SQL Bulk Insert - using " to wrap text fields

nimmi.smith (8/25/2008)
Jeff: Great post-even though this was 3 years ago. I am hoping you can help me with my bcp issue. My file looks like this
Yep... Sergiy is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:54 pm

#862900
RE: Loading text file to SQL Server 2005 using bulk insert

jfbergeron (8/25/2008)
Hi,
I have an issue with using openrowSet:
When using on real data, i got several products that with double quotes in the description, and caused me problems.
Here is an example:
ProductID...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:48 pm

#862899
RE: Loading text file to SQL Server 2005 using bulk insert

jfbergeron (8/20/2008)
Finally got it to work! There was an error with my login, it was not in the right order, needed to put 'Sa' as the third paremeter, not the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:33 pm

#862898
RE: numeric sort of a varchar field

bitbucket (8/25/2008)
na.netjob - you provided some, just some answer to Jeff Moden's question, but NOT enough to allow someone to really help you.
Unanswered is how do you want...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:23 pm

#862897
RE: Covering index is too long, but needed ... what to do?

sql_er (8/25/2008)
Thanks for all the suggestions.
I was able to fix the problem without adding an index, but just re-writing the query.
It was strange how a very simple change in the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:20 pm

#862896
RE: data archiving

If the clustered key is set by date or, perhaps, identity and the identity column is indicative of entry order, then sectional deletes (or insert to archive, delete from source)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:19 pm

#862895
RE: Denormalized table

Agh! My bad... I didn't read the original post as well as I should have. Throwing in a partitioned row number along with the a method similar to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 10:15 pm

#862894
RE: I need help to optmize the query performance

sandeep kumar (8/25/2008)
Use of while loop is equivalent of a read only, forward only cursor which won't save anything. SET based approch is the best way to remove the cursor...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 25, 2008 at 9:54 pm

#862890

Viewing 15 posts - 48,601 through 48,615 (of 59,099 total)