Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,961 through 15,975 (of 59,067 total)

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
RE: Anyone here owning up to this...?

No... but that's hilarious. Like the Yellow M&M said, "He DOES exist". 😛
--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 30, 2016 at 11:52 pm

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

Going back to compatibility level 120 to fix such issues seems just wrong to me. Glad you found a fix.
Speaking of the fix, what was it? 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)

December 30, 2016 at 11:46 pm

#1920181
RE: sa password is lost - need to add Sys Admin Privileges to another account

Lowell (12/30/2016)
Jeff Moden (12/30/2016)
I'm going to have to show my security folks this one. Heh... and everyone says using xp_CmdShell is dangerous. 😛
not all that dangerous, I think, since...
--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 30, 2016 at 11:17 pm

#1920180
RE: Deadlock Problem on a Heap Table

What you included in the original post was a picture of the deadlock graph, not the text, which would have shown the actual code involved.
But, from what you...
--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 30, 2016 at 10:30 pm

#1920177

Viewing 15 posts - 15,961 through 15,975 (of 59,067 total)