Jeff Moden

Forum Replies Created

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

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
RE: Where to place WITH (NOLOCK) ?

Chris Harshman (1/2/2017)
Jeff Moden (12/30/2016)
I'd be very cautious about recommending the use of SNAPSHOT ISOLATION... very cautious. As with any such major feature, there are major caveats.
Kendra Little wrote...
--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 2, 2017 at 3:40 pm

#1920298
RE: Issue with column parsing

Alan.B (1/2/2017)
sgmunson (1/2/2017)
Jeff Moden (12/28/2016)
IIRC, PARSENAME has an element length of NCHAR(128) as a limit on each part it returns and is heavily dependent on the consistent position of items...
--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 2, 2017 at 2:59 pm

#1920296
RE: Best way to publish 2012 SSRS reports on the web

As a bit of a sidebar, it's a real shame that they got rid of sp_MakeWebTask. It was an incredible tool that made SSRS look a bit silly 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)

January 1, 2017 at 2:05 pm

#1920241

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