Jeff Moden

Forum Replies Created

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

RE: If you weren't a DBA, what would you be doing?

Heh... it's funny. If you look back at all the alternatives that folks have listed, a DBA pretty much has to have all those skills combined.
--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 8:45 pm

#1958477
RE: JOIN Question

Thom A - Tuesday, September 5, 2017 2:48 AM
When you want to return data from another table, but retain rows if there...
--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 8:42 pm

#1958475
RE: Independence Day

Ed Wagner - Wednesday, July 5, 2017 6:56 PM
TomThomson - Tuesday, July 4, 2017 3:20 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 8:23 pm

#1958474
RE: Independence Day

TomThomson - Tuesday, July 4, 2017 3:20 AM
The use of "dw" fooled me - I thought that would either result in a...
--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 8:17 pm

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

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