Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,316 through 15,330 (of 59,097 total)

RE: Big Companies are Improving with DevOps

I guess I just don't understand why people think you can "implement" DevOps. You can't implement a culture. You have to enable it and then let it happen.
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)

March 30, 2017 at 8:29 am

#1935738
RE: Instance is under memory pressure. How to relieve from pressure

coolchaitu - Thursday, March 30, 2017 1:30 AM
RAM=30 GB
I'm pretty sure that you've just discovered the reason for your "memory pressure". ...
--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 30, 2017 at 8:14 am

#1935732
RE: Kudos on this choice forum software !!

I've found that copying and pasting from SSMS directly to an SQL Code window makes a train wreck of things. Turns out that they only have limited support for IE...
--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 30, 2017 at 8:10 am

#1935729
RE: Kudos on this choice forum software !!

Have you tried to post any code, yet?
--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 30, 2017 at 1:00 am

#1935640
RE: Convert DATETIME, trim leading zeros

thisisfutile - Wednesday, March 29, 2017 2:26 PM
I sure hope this isn't considered bad etiquette by reviving a 5 year old thread...
--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 29, 2017 at 5:00 pm

#1935623
RE: What Kind of DBA Are You?

hakim.ali - Monday, March 27, 2017 10:16 PM
Jeff Moden - Sunday, September 6, 2015 10:40 AM
--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 28, 2017 at 9:16 am

#1935295
RE: DB MAXDOP Settings

No problem. And thank you! Thanks to your question, I learned something new.
--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 27, 2017 at 7:38 pm

#1935191
RE: Log file growth

Admingod - Monday, March 27, 2017 1:36 PM
Thanks for everyone for the replies. The log growth is happened during index maintenance plan....
--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 27, 2017 at 7:32 pm

#1935190
RE: switch table to partition

Sugesh Kumar - Tuesday, November 13, 2007 11:23 PM
Check for the article on data partitioning in the link given below.http://www.sql-articles.com
Do you have...
--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 27, 2017 at 7:26 am

#1935054
RE: Are the posted questions getting worse?

Michael L John - Sunday, March 26, 2017 7:30 PM
Jeff Moden - Saturday, March 25, 2017 9:05...
--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 27, 2017 at 6:38 am

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

JasonClark - Sunday, March 26, 2017 11:10 PM
Use -b option to Avoid filling the transaction log space. Also, you should drop indexes...
--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 27, 2017 at 6:12 am

#1935037
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

Viewing 15 posts - 15,316 through 15,330 (of 59,097 total)