Jeff Moden

Forum Replies Created

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

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
RE: SQL 2012 sp1 Crash ntdll.dll

Tom Van Harpen - Monday, March 20, 2017 11:48 AM
For the 3rd time in as many weeks, we've had a SQL 2012...
--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:05 pm

#1934969
RE: Launching Products

Steve Jones - SSC Editor - Wednesday, March 22, 2017 8:25 AM
Sean Redmond - Wednesday, March 22,...
--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 9:58 pm

#1934968
RE: Does ReOrg Job change query execution plan?

SQL-DBA-01 - Friday, March 24, 2017 10:44 AM
Hi Experts
I found that suddenly for a procedure the query execution plan changed and 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)

March 25, 2017 at 9:27 pm

#1934967
RE: Are the posted questions getting worse?

GilaMonster - Saturday, March 25, 2017 4:41 PM
DevOps isn't a job! Any company that thinks 'devops' is a title for someone 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 9:05 pm

#1934965

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