Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,651 through 13,665 (of 59,101 total)

RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

Just in case anyone is interested in the side bar of which order the databases are loaded in, here's a list of the database loads on the last startup 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)

November 20, 2017 at 8:34 pm

#1968938
RE: Automatic Plan Correction

Jason A. Long - Monday, November 20, 2017 7:47 PM
Jeff Moden - Monday, November 20, 2017 7:04...
--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)

November 20, 2017 at 7:53 pm

#1968935
RE: List All Jobs and Their Schedules

Got it. Again, thanks for the feedback. It's always good to know what people do and why. I appreciate 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)

November 20, 2017 at 7:51 pm

#1968934
RE: Automatic Plan Correction

Alan.B - Monday, November 20, 2017 7:11 PM
Jeff Moden - Monday, November 20, 2017 7:04 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)

November 20, 2017 at 7:35 pm

#1968931
RE: Automatic Plan Correction

Jason A. Long - Monday, November 20, 2017 5:13 PM
Basically a DTA that doesn't suck...
Heh... THAT, my friend, has yet to be...
--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)

November 20, 2017 at 7:04 pm

#1968927
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

patrickmcginnis59 10839 - Monday, November 20, 2017 6:33 PM
Jeff Moden - Monday, November 20, 2017 3:41 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)

November 20, 2017 at 6:58 pm

#1968924
RE: List All Jobs and Their Schedules

camaro305hp - Monday, November 20, 2017 5:02 PM
Jeff Moden - Monday, November 20, 2017 4:23 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)

November 20, 2017 at 6:52 pm

#1968923
RE: monitor when files get to 80%

myukas - Monday, November 20, 2017 4:24 PM
is there an easy way to monitor and alert when mdf ndf and ldf reach...
--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)

November 20, 2017 at 4:58 pm

#1968917
RE: Holiday parties: Do you love them or hate them?

I attend the company Christmas Party for four reasons:
1. The "meeting" beforehand is where they lay out what happened in the previous year and what's coming up for 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)

November 20, 2017 at 4:31 pm

#1968915
RE: List All Jobs and Their Schedules

camaro305hp - Monday, November 20, 2017 3:57 PM
rwest 44523 - Wednesday, July 19, 2017 8:04 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)

November 20, 2017 at 4:23 pm

#1968913
RE: Log file R drive- What is consuming it

@coolchaitu ,
I see you've flagged two posts as the answer, so I'm curious... What did you actually come up with? What...
--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)

November 20, 2017 at 4:00 pm

#1968909
RE: Trigger table read?

jayg359 - Monday, November 20, 2017 10:40 AM
Jeff Moden - Tuesday, November 14, 2017 7:01 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)

November 20, 2017 at 3:56 pm

#1968906
RE: Creating a PDF from a Stored Procedure

Eric M Russell - Monday, November 20, 2017 12:30 PM
This would actually be a good interview question. If the candidate laughs 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)

November 20, 2017 at 3:53 pm

#1968905
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

patrickmcginnis59 10839 - Monday, November 20, 2017 3:26 PM
Jeff Moden - Sunday, November 19, 2017 12:20 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)

November 20, 2017 at 3:41 pm

#1968903
RE: Help with aggregate function

ger_serrano - Monday, November 20, 2017 9:11 AM
That is excellent guys. Both queries work as expected. I have modified the query 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)

November 20, 2017 at 10:13 am

#1968816

Viewing 15 posts - 13,651 through 13,665 (of 59,101 total)