Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,286 through 15,300 (of 59,063 total)

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

Viewing 15 posts - 15,286 through 15,300 (of 59,063 total)