Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,056 through 41,070 (of 59,102 total)

RE: How can I improve this query or make it more consistent in execution times?

GOOGLE for "Parameter Sniffing SQL Server". I believe that's your problem.
--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)

November 23, 2009 at 9:14 pm

#1083239
RE: Conversion failure with stored procedure?

It's not the code... it's the data. You need to find out which VARCHAR data isn't valid in that column. Start with using ISDATE and go from there.
I...
--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)

November 23, 2009 at 9:09 pm

#1083237
RE: How do I compute for the total of the value in Alias vladd1, vladd2, vladd3, vladd4 or any alternative using declare statement ?

Heh... I just can't resist...
Since all of the following...
SELECT LEN(' '),
LEN(' '),
...
--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)

November 23, 2009 at 8:45 pm

#1083231
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

Before I get started... the article is well written, clear, and easy to understand... I just disagree with the premise of having to resort to any form of RBAR 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)

November 23, 2009 at 7:24 pm

#1083226
RE: Optimizing Cursor Performance

I agree with that whole heartedly, DC. I've found that a well written cursor will frequently beat a home grown While Loop just as you said. I'll also...
--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)

November 23, 2009 at 5:41 pm

#1083214
RE: Are the posted questions getting worse?

Bob Hovious 24601 (11/23/2009)
The article is intended to help novices "get" the fact that there aren't hard and fast answers to some questions.
Heh... a little play on words... to Novices,...
--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)

November 23, 2009 at 5:26 pm

#1083213
RE: running total

chandreshgeria (11/22/2009)
Sir ,
I have not seen any sake in performance of executing query , can you help it out where I doing Wrong
...
--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)

November 23, 2009 at 5:16 pm

#1083212
RE: Convert searched String to number

andy.woodward (11/23/2009)
That makes a lot of sense Jeff thankyou.
The database holds thousands and thousands of records so I will definately benefit from the speed aspect.
Just one question.
you have set 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)

November 23, 2009 at 4:02 pm

#1083199
RE: How using SQL to generate random string?

I'm actually a bit surprised at the high numbers of rejects... seems like for a base 36 set of 6 characters, there should only have been a "chance" of about...
--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)

November 23, 2009 at 3:44 pm

#1083194
RE: Rounding - Is there a better way

Heh... no problem... I just like to know what drives such requirements. Thanks for the feedback. 🙂
--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)

November 23, 2009 at 7:57 am

#1082941
RE: need sample resume for MS SQL DBA

sanketahir1985 (11/20/2009)
Hiii All
I need sample resume for SQL DBA,
can any body guide me, [font="Arial Black"]where will i find the sample resumes[/font].
sanketahir1985 (11/23/2009)
hey i know that how to search on google...
--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)

November 23, 2009 at 6:21 am

#1082905
RE: REPLACE Multiple Spaces with One

Understood but thanks for the reminder...
The real problem is that this type of thing should never happen... it's simple and easy to prevent. Data providers that cough up...
--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)

November 23, 2009 at 6:09 am

#1082900
RE: How using SQL to generate random string?

Dave Ballantyne (11/23/2009)
Hee Hee, No worries Jeff, constructive criticism always welcome 😛
Heh... you're taking it well. Thanks. Just curious... does that mean you're going to change...
--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)

November 23, 2009 at 5:59 am

#1082895
RE: How using SQL to generate random string?

Heh... crap... I didn't realize that it was Dave's article. Didn't mean to blast one of our own but I guess everyone know's I'm serious about it now.
Sorry Dave...
--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)

November 22, 2009 at 7:52 pm

#1082790
RE: How using SQL to generate random string?

No problem with what you posted... I understood what you were doing, Ron and I appreciate it because you're exactly right... folks need to get away from thinking "loops". ...
--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)

November 22, 2009 at 7:43 pm

#1082788

Viewing 15 posts - 41,056 through 41,070 (of 59,102 total)