Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,331 through 15,345 (of 59,101 total)

RE: Database Architecture Question

Good stuff, Jeffrey. Hadn't though about using AG for this because we don't use AG where I work. They have some hardware solution going on using "NIMBLE". I learned something...
--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)

March 26, 2017 at 11:12 am

#1934997
RE: DB MAXDOP Settings

Yeah... I was wrong. They really do mean "Primary and Secondary DATABASES". Here's a reference that's a bit more clear rather than leaving those of us that don't know "in...
--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)

March 26, 2017 at 10:48 am

#1934996
RE: DB MAXDOP Settings

bretknoll - Sunday, March 26, 2017 7:53 AM
Please excuse me if this obvious, but what are primary and secondary databases? Are we...
--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)

March 26, 2017 at 10:37 am

#1934995
RE: Launching Products

xsevensinzx - Saturday, March 25, 2017 10:36 PM
I worked in the video game industry for 7 years before I landed where I'm...
--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)

March 26, 2017 at 9:53 am

#1934992
RE: Update SQL with excel files?

Or download the "ACE" drivers and use those to import the spreadsheet to a work table if it needs to be done more than once.
--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)

March 26, 2017 at 9:35 am

#1934991
RE: Is full backup enough

sqlguy80 - Saturday, March 25, 2017 10:44 PM
Also to mention the last minute issues from other team members who had the backup...
--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)

March 26, 2017 at 9:33 am

#1934989
RE: The Mysterious Case of the Missing Default Value

sqldoubleg - Sunday, March 26, 2017 3:33 AM
Jeff Moden - Saturday, March 25, 2017 7:44 PM
--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)

March 26, 2017 at 9:19 am

#1934988
RE: Database Architecture Question

Mike Scalise - Sunday, March 26, 2017 7:11 AM
Thanks for weighing in, Jeff. So if I'm understanding you correctly, you end up...
--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)

March 26, 2017 at 8:48 am

#1934986
RE: Why DevOps? Employee Satisfaction

Ah.... and again, I have to say... if you think that DevOps is a tool, title, or method, you probably don't get DevOps. It's a culture. The term is rapidly...
--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)

March 26, 2017 at 12:41 am

#1934980
RE: Why DevOps? Employee Satisfaction

Rod at work - Monday, March 20, 2017 8:45 AM
I work in State government, which in our state is traditionally waterfall in...
--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)

March 26, 2017 at 12:39 am

#1934979
RE: Minimal Logging

Heh... man, I'm glad I could find the post above so that I could make this update.
I couldn't, for the life of me, get minimal logging to...
--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)

March 26, 2017 at 12:13 am

#1934978
RE: How to reduce log file size in BCP in?

Just to follow up a bit even though 5 years later, if done correctly and in a single batch, you can BCP all those rows into a table that has...
--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)

March 25, 2017 at 11:38 pm

#1934977
RE: Load data in chunks daily

mayank.pratap01 - Wednesday, March 22, 2017 11:46 PM
I have to load table with around 50M rows but i get a window of...
--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)

March 25, 2017 at 11:06 pm

#1934976
RE: slow update vs fast select

Lynn Pettis - Tuesday, March 21, 2017 12:30 PM
First, is there a reason for this: cast(sbo.docentry
--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)

March 25, 2017 at 10:39 pm

#1934974
RE: Log file growth

Admingod - Monday, March 20, 2017 12:33 PM
How to find what cause the log file growth? This happened during index maintenance.How to...
--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)

March 25, 2017 at 10:28 pm

#1934971

Viewing 15 posts - 15,331 through 15,345 (of 59,101 total)