Jeff Moden

Forum Replies Created

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

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
RE: CPU IS Running mostly above 95%

Carl Federl (8/25/2008)
"could you post a copy of the code that fixed your parameter sniffing problem?"
This application is running under SQL Server 2000 and the analysis consisted of...
--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:49 pm

#862888
RE: MIS in the UK

skenzie (8/25/2008)
And thanks Jeff for spurring me on, even at my age....heh heh. I'm going to apply for the job but making it clear I have no actual qualifications but...
--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:47 pm

#862887
RE: Need help in a query - Accessing and modifying previous row data

Amit Khanna (8/25/2008)
Hi Sg,
WITH C_TEMP AS
(
SELECT T.num,T.OP_Bal,T.quantity,T.OP_Bal + T.quantity AS Closing_Bal
FROM #Temps T
WHERE T.num...
--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:23 pm

#862885
RE: No: of day between two dates

aneeshvarghes (8/24/2008)
I want the count each day seperately
Still doesn't tell me a thing... like I said, tell us exactly what you want by giving us an example of the inputs...
--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:21 pm

#862884

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