Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,946 through 36,960 (of 59,072 total)

RE: Increase buffer size programmatically in SQL 2000 using T-SQL

msforumpost (9/5/2010)
Thanks for the reply . Those are actually 6000 lines of Insert into table statement to insert data... Can u please tell me the name of the undocument stored...
--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)

September 6, 2010 at 2:23 pm

#1217043
RE: What is the use of SQL Injection?

Perry Whittle (9/6/2010)
incidentally Wayne, although i do sort of agree with Jeff and Lynn,
"all pirates should find their own treasure"
i do think that you presented well to the OP....
--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)

September 6, 2010 at 2:15 pm

#1217041
RE: Using DateDiff to calculate days before a Birthday

kenkob (9/5/2010)
It may not be the best way, certainly it is not the only way, it is my way and part of my learning curve.
I agree and no personal attack...
--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)

September 6, 2010 at 1:49 pm

#1217038
RE: The Semantics of NULL in SQL Server 2008

Hugo Kornelis (9/4/2010)
frodriguez.im (9/4/2010)
Now how do you differ an empty or blank field from one with no value? I understand them to be the same.
In a varchar column, the empty...
--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)

September 6, 2010 at 12:44 pm

#1217028
RE: Sending scheduled SQL query results via HTML e-mail using SSIS

Paul Clancy (9/6/2010)
I'm mildly horrified at the notion that anyone might think that I was suggesting HTML-via-mail-via-SSIS as the best or only way to serve this functional problem. My starting...
--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)

September 6, 2010 at 12:37 pm

#1217026
RE: Sending scheduled SQL query results via HTML e-mail using SSIS

David McKinney (9/6/2010)
Jeff Moden (9/4/2010)
And did you see the size of the style sheet that was posted on this thread?....The addition of a style sheet in the discussion...
--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)

September 6, 2010 at 11:24 am

#1217007
RE: Please don’t Tweet this, but…

niall.baird (9/5/2010)
Being possibly the only person in the universe that doesn't have a twitter account, a facebook page, a myspace page or anything else like that (other than a linkedin...
--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)

September 6, 2010 at 10:55 am

#1216999
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

WayneS (9/5/2010)
You might be interested in the article Using XML to Enhance the Performance of String Manipulations[/url]
There's one I missed... I'll check it out. Thanks, Wayne.
--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)

September 6, 2010 at 10:41 am

#1216994
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

WayneS (9/5/2010)
Hugo Kornelis (9/5/2010)
I am sorry, Wayne. I never knew this is configurable. Thanks for teaching me something new. I believe that Paul has already helped you find the posts...
--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)

September 5, 2010 at 7:50 pm

#1216739
RE: What is the use of SQL Injection?

Sooooo... now that we've taught someone how to accomplish SQL Injection, I have to ask... will he use it to avoid injection or carry out revenge on some unsuspecting company?...
--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)

September 5, 2010 at 7:46 pm

#1216738
RE: The Great Debate!

MaricopaJoe (9/5/2010)
The original post was made in the hope that there is some 'recommended practices' from Microsoft. Has anyone see any such white paper?
I don't see the word "Microsoft"...
--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)

September 5, 2010 at 1:21 pm

#1216699
RE: Learning Oracle

Lynn Pettis (9/4/2010)
We are using 8g and 10g. From what has been discussed, one of the databases will be moving from 8g to 10g. This is to eliminate...
--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)

September 5, 2010 at 1:09 pm

#1216697
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

As a bit of a tease and a bit of an explanation as to why my response to all of this is taking so long is {drum roll please and...
--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)

September 4, 2010 at 11:40 pm

#1216621
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Hugo Kornelis (9/4/2010)
Less than two days, and I already have a lot of catching up to do. This topic sure if lively! 😉
Jeff Moden (9/3/2010)
I usually value your opinion 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)

September 4, 2010 at 11:28 pm

#1216620
RE: Hidden or Unknown Job Perks

alen teplitsky (9/4/2010)
dbowlin (9/3/2010)
I worked for a company where the owners were very active in PETA. They offered to pay for spay/neuter of any pets.
I work for a cable...
--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)

September 4, 2010 at 9:48 pm

#1216616

Viewing 15 posts - 36,946 through 36,960 (of 59,072 total)