Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,871 through 33,885 (of 59,099 total)

RE: Replace repeated Char in a string by the Char itself

Jeff Moden (5/22/2011)
Henk Schreij (5/22/2011)
Jeff, you're right, thank you for your explanation.
Sorry for my bold comment. :unsure:
I knew I should have added a smiley face or something. 😀 ...
--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 22, 2011 at 4:28 pm

#1328254
RE: Replace repeated Char in a string by the Char itself

Henk Schreij (5/22/2011)
Jeff, you're right, thank you for your explanation.
Sorry for my bold comment. :unsure:
I knew I should have added a smiley face or something. 😀 I took...
--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 22, 2011 at 4:24 pm

#1328253
RE: Table Variable vs Temp Table, 70-451 preparation questions

GilaMonster (5/22/2011)
Bear in mind that practice exams (MeasureUp, Transcend, etc) are not written by MS. They're written by independent companies based on the MS provided list of what's covered by...
--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 22, 2011 at 3:41 pm

#1328246
RE: How to find all customers that has 2 different tickets in order

Shai Bar-Lev (5/22/2011)
Hi Chris ,
Thanks for the sample SQL code.
I'll be by the customer site and will test both approaches. sample data is a problem due to the nature 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)

May 22, 2011 at 12:21 pm

#1328224
RE: Table Variable vs Temp Table, 70-451 preparation questions

tuseau (5/22/2011)
However, the "correct" answer in the test is apparently to use a table variable, not a temp table. This seems to me both wrong and ridiculous since it 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)

May 22, 2011 at 12:09 pm

#1328222
RE: Query Help

Thomas Abraham (5/18/2011)
In general, I'm becoming a fan of your posts.
Thanks for the great feedback, Thomas. :blush:
If I had a son, I'd name him Million Row Table in your...
--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 22, 2011 at 11:55 am

#1328221
RE: Replace repeated Char in a string by the Char itself

The reason why I use a Temp Table for such things is because a Temp Table persists in SSMS until I drop the table or end the session. 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 22, 2011 at 11:36 am

#1328218
RE: Hints Are Not Always Better

Very well done Rob and Steve! Rob, I hope you do get a precon!
I wish more people would understand what "tuning" is all about. It's not about getting SQL...
--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 22, 2011 at 11:24 am

#1328216
RE: TRigger problem, again Multible rows with update

Wayne is absolutely spot on about the possible performance problem associated with joined UPDATEs. The "target" of the UPDATE MUST be somewhere in the FROM clause (I usually make...
--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 22, 2011 at 10:07 am

#1328204
RE: Reverse string without built in functions

abhi620 (5/20/2011)
i think this is good solution for...
With only very few exceptions, the RBAR of a WHILE loop is almost never a good solution. Please try it on a...
--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 21, 2011 at 10:06 pm

#1328154
RE: Two questions in mind (for genralized approach)

Ninja's_RGR'us (5/18/2011)
Select into could cause recompiles and slow you down.
True enough and I do realize you said "could" but just to be sure... The blinding speed of a SELECT/INTO...
--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 21, 2011 at 11:08 am

#1328116
RE: Replace repeated Char in a string by the Char itself

Henk Schreij (5/21/2011)
Sorry Jef, the REPLACE method which you explained in your article, enhanced by Michael Meierruth, was just what I was looking for.
Till that moment my mind was struggled...
--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 21, 2011 at 10:43 am

#1328112
RE: Help to Bring My SQL server Skills back

a-elnajjar (5/21/2011)
Hi all,
I am Front End Web Developer. I never use SQL Server since I graduate from school and I really need some Help From Database Gurus .I am...
--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 21, 2011 at 10:40 am

#1328111
RE: Parse String to find a letter...

Jeff Moden (5/20/2011)
WayneS (5/20/2011)
Very nice Sean.
One thing to point out (for all solutions for this) is that if you have a case-sensitive collation, you will want to force the strings...
--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 20, 2011 at 4:09 pm

#1328022
RE: Parse String to find a letter...

WayneS (5/20/2011)
Very nice Sean.
One thing to point out (for all solutions for this) is that if you have a case-sensitive collation, you will want to force the strings to be...
--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 20, 2011 at 4:08 pm

#1328021

Viewing 15 posts - 33,871 through 33,885 (of 59,099 total)