Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,221 through 38,235 (of 59,098 total)

RE: Parsing millions of records without index

rajiv.varma (5/25/2010)
@jeff
I agree I stripped down the code for posting purpose, but the actual code definitely works. The whole reason behind combining data from 4 columns is that if there...
--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)

May 25, 2010 at 5:32 pm

#1172416
RE: Getting most common value from several fields into one record

kramaswamy (5/25/2010)
This scenario is not actually important to me - I'm fine with choosing any one of them.
Heh... now that would have been nice to know up front. 😛 ...
--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)

May 25, 2010 at 5:26 pm

#1172414
RE: Warning or no warning?

lmu92 (5/25/2010)
But...
wouldn't it be nice to have a SQL Server setting (like IDENTITY_INSERT), something like STRING_TRUNC with ON as a default (truncate strings, like it currently does...)? That would allow...
--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)

May 25, 2010 at 5:08 pm

#1172410
RE: Substring function generates error when I try to use (LEN(expression)-1) as length argument

Cheat... no CASE required.
SELECT ISNULL(SUBSTRING(@exp1,1,(LEN(NULLIF(@exp1,'')) - 1)),'')
--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)

May 25, 2010 at 4:07 pm

#1172394
RE: Warning or no warning?

I'd prefer that it operate like it does... no warning. I'll sometimes (many times, actually) use it as a cheater (LEFT).
--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)

May 25, 2010 at 4:00 pm

#1172390
RE: Passing many parameters to a stored procedure

Heh... yep... depends on whether you want to be nice to the "pipe" or not.
--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)

May 25, 2010 at 3:55 pm

#1172388
RE: Convert this date to calendar format...?

tacy.highland (5/25/2010)
Thank you everyone for the quick and knowledgeable responses! This works wonderfully now.
Thank you so much!
Tray... I have a concern about your floating year code with the date format...
--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)

May 25, 2010 at 3:54 pm

#1172387
RE: http call embedded in stored proc

Oddly enough, I was looking for a similar thing today. I found the following. Not sure it applies here but might be helpful in what to look for...
Declare...
--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)

May 25, 2010 at 3:46 pm

#1172383
RE: High Transactions per second

Grant Fritchey (5/25/2010)
Jeff Moden (5/25/2010)
Grant Fritchey (5/25/2010)
Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system....
--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)

May 25, 2010 at 11:09 am

#1172249
RE: High Transactions per second

Grant Fritchey (5/25/2010)
Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system. You should be working...
--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)

May 25, 2010 at 8:33 am

#1172100
RE: Cursor performance

Just to add to what has already been said...
There are a lot of places where well meaning folks use Cursors/While Loops because a job "can't be done using set...
--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)

May 25, 2010 at 8:29 am

#1172099
RE: Passing many parameters to a stored procedure

If you pass XML, then you'll need to shred it just like if you pass delimited data that needs to be parsed. A lot of folks use XML for...
--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)

May 25, 2010 at 8:13 am

#1172094
RE: Calculation in group by query.

Pravin Patel-491467 (5/25/2010)
Friends,
Thanks a lot for all your help and giving your precious time behind this stuff.
I am posting one more stuff related this stuff in same forums TSQL(SS2K5). If...
--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)

May 25, 2010 at 7:44 am

#1172070
RE: Parsing millions of records without index

By the way, I have to ask... the code you posted in your original post has so many errors in it that it would never have come close to working....
--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)

May 25, 2010 at 7:39 am

#1172063
RE: Parsing millions of records without index

So let's ask the question, then... does the underlying table in the view have the cc, yy, mm, dd columns or does it have a viable DATE or DATETIME column,...
--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)

May 25, 2010 at 7:25 am

#1172049

Viewing 15 posts - 38,221 through 38,235 (of 59,098 total)