Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,486 through 34,500 (of 59,102 total)

RE: Finding unique values in strings

Let's try something similar but different. 😀
First, it's impossible to determine if what we've done will have the correct performance without a wad of test data. With that 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)

March 27, 2011 at 5:20 pm

#1304138
RE: Finding unique values in strings

David Krauus (3/26/2011)
Yes Lynn, that is what I am wanting to end up with.
I have made this work with some pattern matching queries in a while loop. Again, not very...
--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)

March 27, 2011 at 4:49 pm

#1304137
RE: Dates must be shown as string with comma separtor

sujavani.l (3/26/2011)
I have table
User ID Date
1 01\03\2011
1 02\03\2011
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)

March 27, 2011 at 3:30 pm

#1304132
RE: Output

Alicia Rose (3/27/2011)
Jim
Can you please help by explaining what is the purpose of the stored proc and what are the possible test cases and test scripts for it.
Thanks,
Why not just...
--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)

March 27, 2011 at 2:27 pm

#1304119
RE: Temp DB

ALZDBA (3/27/2011)
Tempdb doesn't just use model.
:w00t:
Ummmm.... not quite right. From the first sentence you find when you lookup "Model Database" in BOL...
The model database is used as 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)

March 27, 2011 at 2:14 pm

#1304118
RE: Query Timeout

SQL33 (3/18/2011)
Good morning all.. everything I read seems to indicate that query timeouts when set to "0" means infinite... no timeout. Yet, when I query a table 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)

March 27, 2011 at 2:09 pm

#1304117
RE: Query Req: student & attendance table

waqarnaeem2 (3/27/2011)
Iam a fresh here
I have a table Attendance & student ..
I want to fetch the records at the end of month that date with studentid which are not present...
--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)

March 27, 2011 at 2:05 pm

#1304114
RE: Are the posted questions getting worse?

GilaMonster (3/27/2011)
Jeff Moden (3/27/2011)
Oh yes... I know it's partially correct. I just couldn't understand why anyone who knows of SQL would bring it up even as partial justification 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)

March 27, 2011 at 1:52 pm

#1304109
RE: Are the posted questions getting worse?

Lynn Pettis (3/26/2011)
Okay, poll time. How many of you are getting tired of Celko and his high horse?
I may be wrong, but I think I could count on one...
--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)

March 27, 2011 at 1:31 pm

#1304102
RE: Are the posted questions getting worse?

GilaMonster (3/26/2011)
Jeff Moden (3/26/2011)
Oddly enough, I've seen a couple of posts on SSC and a fair number more on other forums where people say index maintenance is not important 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)

March 27, 2011 at 1:22 pm

#1304097
RE: Are the posted questions getting worse?

Tom.Thomson (3/27/2011)
I wouldn't dream of joining in, especially at this late stage.
Sage advice. I won't even look. Thanks Tom.
--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)

March 27, 2011 at 1:18 pm

#1304095
RE: Are the posted questions getting worse?

WayneS (3/27/2011)
Grant Fritchey (3/27/2011)
Jeff Moden (3/26/2011)
Koen Verbeeck (3/25/2011)
Maybe an article on why it is not necessary to maintain indexes. Who needs them right?
(but maybe again, someone picks this up 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)

March 27, 2011 at 1:14 pm

#1304093
RE: Are the posted questions getting worse?

Grant Fritchey (3/27/2011)
Oh heck. You can just cut all the maintenance plans now. We only need to prop up these old style databases for another year or two. Then everything...
--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)

March 27, 2011 at 1:12 pm

#1304092
RE: How to summarise, listing on same line

timotech (3/26/2011)
Thanks Jeff, i already solved the problem and only forgot to post it here. Thanks so much for your reply, it shows u care. I appreciate.
Thank you for 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)

March 27, 2011 at 1:01 pm

#1304091
RE: Problem: how to realize custom order

@Birby1974,
Did Wayne's solution work for you or what?
--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)

March 26, 2011 at 2:00 pm

#1303984

Viewing 15 posts - 34,486 through 34,500 (of 59,102 total)