Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,991 through 16,005 (of 59,101 total)

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
RE: How to defrag tables by filegroup

The script at the following link will help.
https://gallery.technet.microsoft.com/scriptcenter/c7483555-cc22-4f6c-b9c4-90811eb3bdb6
--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:00 pm

#1920240
RE: Is there a matured solution to ETL excel data?

Thanks for the endorsement, Ed. And Happy New Year to everyone!
--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)

December 31, 2016 at 10:28 pm

#1920227
RE: What Will 2017 Bring?

call.copse (12/31/2016)
Jeff Moden (12/30/2016)
Since I've also gone over 5 years with this company, it means I'm finally up to 3 weeks of vacation again. I might even be able...
--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)

December 31, 2016 at 5:15 pm

#1920221
RE: Deadlock Problem on a Heap Table

lmarkum (12/31/2016)
TheSQLGuru (12/31/2016)
Jeff Moden (12/30/2016)
TheSQLGuru (12/30/2016)
Jeff Moden (12/30/2016)
TheSQLGuru (12/30/2016)
Jeff: "Another potentially very serious problem with all of this is the idea that a lot of the rows will suffer a...
--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)

December 31, 2016 at 5:06 pm

#1920219
RE: recommendation of tempb files

In the past, a lot of people have recommended multiple files for TempDB only if TempDB has a problem. And, in the past, I've ignored that advice because systems...
--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)

December 31, 2016 at 9:33 am

#1920210
RE: recommendation of tempb files

kevaburg (12/31/2016)
Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.
Experience that I have gathered has shown me that an initial Installation with 5 datafiles with...
--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)

December 31, 2016 at 9:14 am

#1920208
RE: A transport-level error has occurred in local VPN connection, But not in RDP.

kek01 (12/31/2016)
Your network may have a filter in place that is blocking that command. Yes, even in a commment. I have the exact thing happening. If I switch to a...
--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)

December 31, 2016 at 8:37 am

#1920202
RE: Huge regression after upgrading from 2014 to 2016

Phil Parkin (12/31/2016)
Jeff Moden (12/31/2016)
kevaburg (12/31/2016)
I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server 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)

December 31, 2016 at 8:34 am

#1920201
RE: Huge regression after upgrading from 2014 to 2016

kevaburg (12/31/2016)
I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server for the Migration I forgot...
--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)

December 31, 2016 at 7:00 am

#1920196
RE: Are the posted questions getting worse?

Man, I hope they get the new system they're working on in place soon. The SPAM has been brutal and I know I'm not the only monitor hiding 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)

December 31, 2016 at 1:00 am

#1920187
RE: Huge regression after upgrading from 2014 to 2016

Thanks for taking the time for the feedback.
Yeah... the "fix" I was talking about was in the code changes that you said you couldn't release for a couple of weeks....
--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)

December 31, 2016 at 12:36 am

#1920185
RE: Disk storage for audit type tables

How often are the audit tables actually read? I ask because such things usually end up being the biggest things in the database and during an emergency restore, can...
--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)

December 31, 2016 at 12:23 am

#1920183

Viewing 15 posts - 15,991 through 16,005 (of 59,101 total)