Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,836 through 17,850 (of 59,102 total)

RE: Are the posted questions getting worse?

ChrisM@Work (4/22/2016)
Phil Parkin (4/22/2016)
BLOB_EATER (4/22/2016)
He lost me on freezer performance...
The walking freezer is what I want to see.
Manchester. That's where my ex wife lives.
BWAAA-HAAAA!!! (oops... sorry. Did that come...
--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)

April 22, 2016 at 8:16 am

#1873915
RE: Reaping the benefits of the Window functions in T-SQL

lucyliu0301 (4/22/2016)
Good article, well, lengthy. There are better areas to demonstrate the benefit of window functions than parsing strings. For example, when you need to compare rows based on some...
--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)

April 22, 2016 at 8:12 am

#1873913
RE: Creating an Index Strategy

Grant Fritchey (4/14/2016)
I know you're not drinking the bong water. Not at all. However, I have seen scans hurt performance when the indexes were fragmented. Rebuilding helped, and not because...
--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)

April 21, 2016 at 6:54 pm

#1873814
RE: Creating an Index Strategy

TheSQLGuru (4/14/2016)
Grant Fritchey (4/14/2016)
Jeff Moden (4/14/2016)
That's what I thought, as well, but even on the predominately "batch-needs-scans" databases, performance hasn't suffered. Heh... of course, that could be because 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)

April 21, 2016 at 6:45 pm

#1873813
RE: Select records in hierarchical order

@henryvuong1000,
Did that do it for you or did you end up doing something else? If something else, please take a minute andpost it.
--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)

April 21, 2016 at 6:33 pm

#1873810
RE: Successful Projects

manie (4/17/2016)
Jeff, my sincere apologies, I did not mean to take you on like this and I fully agree with you. You know, I have been a developer now 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)

April 21, 2016 at 6:26 pm

#1873809
RE: How to replace multiple items in a column in sql server express table

ironryon (4/21/2016)
GilaMonster (4/21/2016)
Oh, so what, in the spreadsheet tells you what row in the table the new email address belongs to?
Hi GilaMonster
No it wont tell me what row. 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)

April 21, 2016 at 5:54 pm

#1873808
RE: The Hidden Trigger

mjh 45389 (4/21/2016)
I should have said dislike although I will keep hate for tailgaters! Why? Before I had to give up motorcycling some lowlife tailgater punted me down some roadworks!!!
Ah......
--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)

April 21, 2016 at 5:29 pm

#1873806
RE: The Hidden Trigger

Gary Varga (4/21/2016)
I have just been called out on the way I was looking at someone who attempted to tell me what a trigger was "...SQL Server, the world where...
--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)

April 21, 2016 at 4:59 pm

#1873804
RE: Processing strings.

Solomon Rutzky (4/20/2016)
•"tower of Babel" blah blah blah -- while an interesting topic on its own, the "Tower of Babel" discussion is entirely orthogonal to this particular thread, and 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)

April 21, 2016 at 2:31 pm

#1873784
RE: Sargible cases for Cast,Convert, and RTRIM

Yep. Understood on the dynamic seek pattern you spoke of. My question is why it's using "Open/Open" instead of "Closed/Open".
--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)

April 21, 2016 at 2:26 pm

#1873783
RE: why we should delete old data and what could be the chunk size for delete 2.5 million records

John Rowan (4/21/2016)
Good stuff Jeff. I never worked with a DB large enough to really consider partitioning until after 2005 when table partitioning came out and I've worked primarily...
--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)

April 21, 2016 at 2:10 pm

#1873779
RE: why we should delete old data and what could be the chunk size for delete 2.5 million records

John Rowan (4/20/2016)
In addition to what Hugo has stated, you may consider looking into partitioning your table by date (month) if you can. This requires Enterprise Edition, but it...
--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)

April 21, 2016 at 8:24 am

#1873655
RE: The Hidden Trigger

mjh 45389 (4/20/2016)
I hate triggers as much as tailgaters!
I love tailgaters. It's easy to know who to sue when you need to stop short. 😀
--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)

April 21, 2016 at 7:37 am

#1873632
RE: The Hidden Trigger

Triggers are no more hidden than (for example) FKs, cascading FKs, computed columns, or even views and functions (in some cases).
While I feel the angst the some developers feel 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)

April 21, 2016 at 7:35 am

#1873629

Viewing 15 posts - 17,836 through 17,850 (of 59,102 total)