Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,501 through 43,515 (of 59,063 total)

RE: Performance Issues with Dynamic SQL

Reddy B (6/8/2009)
Thanks a lot, Barry. I really appreciate all of your help. You blog pointed me to the right direction.
Great Job.
-B
Enquiring minds want to know... which direction did...
--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)

June 8, 2009 at 9:39 pm

#1006402
RE: sql text

Yep... I agree... profiler. The link that Wayne points to contains just about everything you'll need to know.
Of course, you could always just ask the user what they're running....
--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)

June 8, 2009 at 9:36 pm

#1006401
RE: convert row to column

Kokfai,
You'll find that most folks like to test their answers before posting them. Instead of posting the data as a graphic, please see the link in my signature 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)

June 8, 2009 at 9:31 pm

#1006400
RE: Dates Between From date and To Date

pramod_yg (6/8/2009)
Thanks a lot Guys... it was really helpful.
Thank YOU 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)

June 8, 2009 at 4:35 pm

#1006345
RE: Are the posted questions getting worse?

jcrawf02 (6/8/2009)
Florian Reischl (6/8/2009)
tosscrosby (6/8/2009)
Florian Reischl (6/8/2009)
Oups!
A typo in my "Smurf"...
I didn't know if you call him "Daddy" or "Papa". Just thought "Daddy" is more common in US.
Thanks Jeff!
Only in...
--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)

June 8, 2009 at 2:55 pm

#1006317
RE: buld a rule with Numeric chars only

Lowell (6/8/2009)
thanks everyone; RBarryYoung made the light go on when he said "escape" the second minus sign.
Lynn's example works, as well as using a different rule, which in turn...
--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)

June 8, 2009 at 12:55 pm

#1006268
RE: Are the posted questions getting worse?

GilaMonster (6/8/2009)
Lynn Pettis (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?
http://www.sqlservercentral.com/Forums/Topic730611-8-1.aspx
Oh, great, our "PhD Candidate". Could have warned us on that one, Gail.
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)

June 8, 2009 at 12:32 pm

#1006255
RE: Are the posted questions getting worse?

tosscrosby (6/8/2009)
Florian Reischl (6/8/2009)
Sometimes I'm feelin' like "Daddy Snarf" on this page...
Edit: Do you understand German?
I don't understand German. WTF does that mean?...goggle didn't help much! :w00t:
Bwaa-Haaa!!!! I think...
--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)

June 8, 2009 at 12:28 pm

#1006249
RE: "Greek" data in my SQL table

Heh... just replace the names with NEWID().
--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)

June 8, 2009 at 12:10 pm

#1006229
RE: CTE question

Greg,
One of the supposed advantages listed above for a CTE is if you have to reference the query it contains more than once. Let me say how dangerous that...
--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)

June 8, 2009 at 11:55 am

#1006217
RE: CTE question

Ramesh (5/29/2009)
The 3rd biggest thing is that you can write recursive queries using CTE.
... and kill yourself with hidden RBAR that rivals that of a 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)

June 8, 2009 at 11:53 am

#1006213
RE: buld a rule with Numeric chars only

Lowell,
The answer to your +- problem is that if you wish to include the dash in the pattern, it's easiest to do if you list it first so that it's...
--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)

June 8, 2009 at 11:37 am

#1006203
RE: buld a rule with Numeric chars only

Carl Federl (6/8/2009)
Perhaps I am missing something, but what is wrong with the system function "isnumeric" ?
CREATE RULE [dbo].[NumericCharsOnly]
AS
ISNUMERIC(@value) = 1
GO
Here's one of many problems with ISNUMERIC...
--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)

June 8, 2009 at 11:35 am

#1006201
RE: What SQL Server Sites do you use?

Heh... after reviewing the FAQ for StackOverflow, I have a couple of problems with that site... first, they want you to be both honest and nice. Most people interpret...
--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)

June 7, 2009 at 9:28 pm

#1005899
RE: Sum of top n rows

Sergiy (6/7/2009)
Jeff Moden (6/6/2009)
Amazing... what the hell did the boys in Redmond do? The code posted above by arijit works just dandy in 2k5. The error appears when...
--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)

June 7, 2009 at 9:11 pm

#1005897

Viewing 15 posts - 43,501 through 43,515 (of 59,063 total)