Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,976 through 15,990 (of 59,101 total)

RE: Query took a nose dive

When is the last time you rebuilt statistics on the other tables that you're joining to this 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)

January 5, 2017 at 10:37 am

#1920936
RE: Split Function Usage for Multiple Multi-Select Parameters

You can find the article on the improvements made to the DelimitedSplit8K function with performance tests against other types of splitters as well as the code (see the RESOURCES section...
--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)

January 5, 2017 at 10:26 am

#1920933
RE: Deadlock Problem on a Heap Table

Or, do the BSOFH thing. 😉 Set up an alert to email the devs and their boss every time a deadlock occurs. Make sure it also get's...
--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)

January 5, 2017 at 10:22 am

#1920931
RE: NEWBIE TO THE DBA LIFE

I realize this post has been around for a while but my recommendation is that if you want to be a really good DBA, you'd better be really good at...
--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)

January 5, 2017 at 8:03 am

#1920884
RE: Most likely answering my own question but ..

Stuart Davies (1/5/2017)
As the title says - I think I'm answering my own question, but periodically I see the front page of the the forums have some pink borders around...
--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)

January 5, 2017 at 8:00 am

#1920883
RE: Merge consecutive rows into single row

Why not just replace the embedded carriage returns with an empty string?
--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)

January 5, 2017 at 7:48 am

#1920880
RE: Are there any limits to Pivoting

I'll also say that none of this should require such a load on TempDB. It's a very strong indicator that there's at least one (and it only takes 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)

January 5, 2017 at 7:40 am

#1920876
RE: Application Upgrade and Index Rebuild

chuck.forbes (1/4/2017)
First off, I appreciate all of the education everyone's been providing to me over the last year and a half.
After reading over everyone's suggestions, I think there's a couple...
--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)

January 4, 2017 at 8:55 am

#1920664
RE: Are the posted questions getting worse?

BrainDonor (1/4/2017)
DBMS of the year, apparently - http://db-engines.com/en/blog_post/67
At a 100,000 foot view, sounds more like a report on marketing success than anything else. 🙂
--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)

January 4, 2017 at 8:06 am

#1920629
RE: Long running data flow task

karen.ferrara (1/4/2017)
What we found is that one of the underlying tables used in one of the views the query uses had 20 million + rows. Rebuilding the indexes prior...
--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)

January 4, 2017 at 8:00 am

#1920626
RE: Long running data flow task

Re-reading the original post, I'd also check and see what was going on in the form of blocking during those times on the remote server.
--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)

January 3, 2017 at 7:37 pm

#1920531
RE: Help with XML Splitter De-entitization, please.

Matt Miller (#4) (1/3/2017)
Hi Jeff -
I went into hibernation for a bit, only to come out and find you dabbling in XML..... Small wonders never cease I guess 🙂
I...
--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)

January 3, 2017 at 7:35 pm

#1920530
RE: Calculating Work Days

Spot on, Luis! Thanks for the update.
--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)

January 3, 2017 at 7:29 pm

#1920528
RE: Are the posted questions getting worse?

Luis Cazares (1/3/2017)
Michael L John (1/3/2017)
Just putting the finishing touches on a new reporting server.
I run this old legacy ETL process that nobody knows about, and nobody remembers, 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)

January 3, 2017 at 7:27 pm

#1920527
RE: Where to place WITH (NOLOCK) ?

Chris Harshman (1/3/2017)
Jeff Moden (1/2/2017)
...That's what I'm talking about. Just like the folks that casually recommended the use of WITH(NOLOCK), there are ramifications and risks that must be fully...
--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)

January 3, 2017 at 8:59 am

#1920411

Viewing 15 posts - 15,976 through 15,990 (of 59,101 total)