Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,301 through 15,315 (of 59,063 total)

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
RE: Database Architecture Question

I don't know what your hardware is like but we use SAN snapshots for things like this. It's nearly instantaneous. Each SAN manufacturer seems to have their own way 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 8:42 pm

#1934964
RE: Is full backup enough

OMG!!! Make that 6 posts on the same subject.
https://www.sqlservercentral.com/Forums/1861649/Moving-2-TB-600-databases-from-32-bit-SQL-Server-2008-R2-to-64-bit-SQL-Server-2014-from-Friday-night
You now have the steps to take. Just do 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 8:34 pm

#1934963
RE: Is full backup enough

Whup! Lookie there! Yet another post on the same subject more than a month ago.
https://www.sqlservercentral.com/Forums/1858895/Upgrading-from-SQL-Server-2008R2-Std-Ed-on-32-bit-hardware-to-SQL-Server-2012-Ent-64-bit-on-64-bit-h
What really sucks about this is that Joe Pattyn gave the...
--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 8:27 pm

#1934962
RE: Is full backup enough

Make that a total of 4 posts on the similar subject now.
https://www.sqlservercentral.com/Forums/1862600/moving-several-large-databases-from-old-hardware-Live-to-new-hardware
Seems like we've gone from 40 databases to 500 database to 1200 databases back to 500...
--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 8:18 pm

#1934961

Viewing 15 posts - 15,301 through 15,315 (of 59,063 total)