Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,806 through 17,820 (of 59,069 total)

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
RE: How to replace multiple items in a column in sql server express table

ironryon (4/21/2016)
Hi 🙂
Can anyone help me with a job I have to do -
I have an sql server express db where 1 table lists certain users data -...
--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:52 am

#1873596
RE: Arithabort and Set Ansi warning defaults

Rin Sitah (4/21/2016)
Hi There,
Im a bit puzzled by how sql is behaving and am wondering if someone can shed some light on this.
The default on our database for arithabort 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)

April 21, 2016 at 6:47 am

#1873591
RE: Processing strings.

Solomon Rutzky (4/20/2016)
Actually, all of the statements quoted directly above make absolutely no sense, and reflect a complete misunderstanding of .NET. .NET is structured very similarly to Java: source code...
--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 20, 2016 at 9:37 pm

#1873502

Viewing 15 posts - 17,806 through 17,820 (of 59,069 total)