Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,741 through 25,755 (of 59,099 total)

RE: Are the posted questions getting worse?

Greg Edwards-268690 (10/4/2013)
Ed Wagner (10/4/2013)
Jeff Moden (10/3/2013)
WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
Not going. Prepping 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)

October 5, 2013 at 12:24 pm

#1656103
RE: Need Help on Fastest Search Logic

Again, I apologize for this taking so long. Real life had me hopping and it took a little thought on how to generate the test data and still have...
--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)

October 5, 2013 at 10:41 am

#1656099
RE: Need Help on Fastest Search Logic

I have the desired process down to 11 seconds using my two favorite tools of "Divide'n'Conquer" and the DelimitedSplit8K function on my old 32 bit single 1.8 Ghz cpu 11...
--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)

October 5, 2013 at 12:25 am

#1656081
RE: Need Help on Fastest Search Logic

Generating random CSV's with a random number of elements from the list in Table1 was a bit of a chore. The items wouldn't come out random so I had...
--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)

October 4, 2013 at 11:42 pm

#1656080
RE: Finding and picking from Duplicates...

RedBirdOBX (10/4/2013)
This should be simple but I' having a hard time wrapping my head around this one late on a friday afternoon.
I have a table containing people and except 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)

October 4, 2013 at 5:12 pm

#1656067
RE: Create loop to send out emails

There are plenty of ways around using a cursor for this... it's just not necessary to find one because THIS type of task is precisely what Cursors were designed to...
--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)

October 4, 2013 at 5:00 pm

#1656066
RE: exception handling: how would you do it?

Sean Pearce (10/4/2013)
AndrewSQLDBA (10/3/2013)
Sorry, but I do not see any example using Dynamic SQL. I see the examples using straight Transact SQL.
I NEVER, EVER use Dynamic SQL. No matter what.
Andrew...
--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)

October 4, 2013 at 2:10 pm

#1656046
RE: Running out of workers

ELLEN-610393 (10/3/2013)
Gail,
I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several thousand worker...
--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)

October 4, 2013 at 2:06 pm

#1656045
RE: Generate and send report via email in PDF format which method better

Gergely Mészáros (10/4/2013)
If we want to do such things, we have to get over a long process (approvals etc..).
Greg, there's a reason for that long process and if you bypass...
--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)

October 4, 2013 at 8:16 am

#1655915
RE: Group Islands of Contiguous Dates (SQL Spackle)

IgorMi (10/4/2013)
Nice article!
I immediately applied the code (with minor changes) on another database, and it worked!
Thanks Jeff.
Regards,
IgorMi
Very cool! Thanks for the feedback. I love success stories.
--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)

October 4, 2013 at 7:57 am

#1655906
RE: Group Islands of Contiguous Dates (SQL Spackle)

Thanks for the feedback, Johan. It's always a pleasure to hear from you.
--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)

October 4, 2013 at 7:56 am

#1655904
RE: Is this right if i will do my project this way?..

enriquezreyjoseph (10/3/2013)
Koen Verbeeck (10/3/2013)
Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project...
--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)

October 3, 2013 at 9:05 pm

#1655730
RE: Inline Valued Function query...

dwain.c (10/3/2013)
Jeff Moden (10/3/2013)
Rather, it's an mTFV (Multiline Table Valued Function) and those can be as bad or worse than a Scalar Function.
They can?
Not that I'm...
--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)

October 3, 2013 at 8:55 pm

#1655728
RE: Are the posted questions getting worse?

WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
Not going. Prepping for the "great migration" from 2005 to 2012...
--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)

October 3, 2013 at 4:53 pm

#1655712
RE: Performance When dropping multiple tables

Steve Smith-163358 (10/3/2013)
Thank you all very much for your replies, and thank you Jeff for the excellent article that Alan linked to earlier.
I had often read about the merits 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)

October 3, 2013 at 1:28 pm

#1655673

Viewing 15 posts - 25,741 through 25,755 (of 59,099 total)