Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,401 through 14,415 (of 59,097 total)

RE: Update Statistics..

Arsh - Tuesday, September 5, 2017 10:38 PM
Hi Jeff. Couldn't convince the team I am working with. There's no DBA except...
--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)

September 6, 2017 at 7:42 pm

#1958471
RE: What is your definition of a DBA?

TomThomson - Wednesday, September 6, 2017 5:18 PM
allinadazework - Wednesday, September 6, 2017 1:36 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)

September 6, 2017 at 7:29 pm

#1958470
RE: Stalled Query?

alex.sqldba - Wednesday, September 6, 2017 12:48 PM
Aye, I supose it is quite large amount of data. Just in my mind 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)

September 6, 2017 at 4:44 pm

#1958466
RE: Remote query gets killed after ten minutes

bmg002 - Wednesday, September 6, 2017 1:34 PM
Jeff Moden - Wednesday, September 6, 2017 1:07 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)

September 6, 2017 at 4:25 pm

#1958464
RE: Determine Monday of next month and Monday of next week

Understood but my big question was on what the start of a month and year should be. For example, should a month start on the first of the month or...
--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)

September 6, 2017 at 4:19 pm

#1958462
RE: Help with XML Splitter De-entitization, please.

Matt Miller (4) - Tuesday, January 3, 2017 7:45 PM
Jeff Moden (1/3/2017)
It's for a small series of articles I'm working on called...
--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)

September 6, 2017 at 2:15 pm

#1958445
RE: huge diffence direct query vs query view

Try adding an Option (RECOMPILE) to the code that calls the view. I've seen it help before (slightly different circumstance involving minimal logging that wouldn't minimally log without it) just...
--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)

September 6, 2017 at 1:31 pm

#1958434
RE: What is your definition of a DBA?

Eric M Russell - Wednesday, September 6, 2017 11:03 AM
Jeff Moden - Tuesday, September 5, 2017 3:10...
--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)

September 6, 2017 at 1:24 pm

#1958432
RE: Remote query gets killed after ten minutes

bmg002 - Wednesday, September 6, 2017 8:18 AM
To me, it sound then like
--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)

September 6, 2017 at 1:07 pm

#1958427
RE: Determine Monday of next month and Monday of next week

gvoshol 73146 - Wednesday, September 6, 2017 5:32 AM
Jeff Moden - Tuesday, September 5, 2017 2:55 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)

September 6, 2017 at 1:04 pm

#1958426
RE: Slow queries during busy times

Casper101 - Wednesday, September 6, 2017 8:35 AM
I would like to ask one more thing:
I am seeing a high ratio of Recompilation...
--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)

September 6, 2017 at 12:58 pm

#1958424
RE: Slow queries during busy times

TheSQLGuru - Wednesday, September 6, 2017 11:16 AM
That is an awesome response Jeff!! Thanks. Worthy of an article actually, but it (kinda)...
--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)

September 6, 2017 at 12:51 pm

#1958422
RE: Infrastructure Recommendations - Memory vs Processors

jackimo - Tuesday, September 5, 2017 7:26 AM
So I've been tasked to plan a new SQL Server environment, with very little guidance...
--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)

September 6, 2017 at 12:35 pm

#1958419
RE: How to handle business hour loads?

Chris Harshman - Wednesday, September 6, 2017 6:42 AM
Jeff Moden - Tuesday, September 5, 2017 3:03 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)

September 6, 2017 at 12:26 pm

#1958417
RE: remove spaces in strings

ThomasRushton - Wednesday, September 6, 2017 7:35 AM
Jeff Moden - Tuesday, September 5, 2017 1:26 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)

September 6, 2017 at 12:23 pm

#1958416

Viewing 15 posts - 14,401 through 14,415 (of 59,097 total)