Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,636 through 13,650 (of 59,095 total)

RE: Question regarding on Premise or to AWS

The non-premium rates have a charge for every 10,000 "transactions". They don't define what a transaction is, though, or at least I've not found it yet. If a "transaction" is...
--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 21, 2017 at 4:56 pm

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

Jason A. Long - Tuesday, November 21, 2017 3:28 PM
Ed Wagner - Tuesday, November 21, 2017 1:34...
--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 21, 2017 at 4:49 pm

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

Jason A. Long - Tuesday, November 21, 2017 10:33 AM
Eirikur Eiriksson - Tuesday, November 21, 2017 10:16...
--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 21, 2017 at 11:51 am

#1969070
RE: Automatic Plan Correction

WayneS - Tuesday, November 21, 2017 8:08 AM
Jason A. Long - Monday, November 20, 2017 5:13 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 21, 2017 at 8:22 am

#1969000
RE: Automatic Plan Correction

WayneS - Tuesday, November 21, 2017 8:04 AM
Jeff Moden - Monday, November 20, 2017 7:53 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 21, 2017 at 8:16 am

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

GilaMonster - Monday, November 20, 2017 11:53 PM
Jeff Moden - Monday, November 20, 2017 8:34 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 21, 2017 at 8:13 am

#1968994
RE: monitor when files get to 80%

myukas - Tuesday, November 21, 2017 7:38 AM
so i am selecting this select name,physical_name,max_size,growth,is_percent_growth from sys.master_files i think this is what i want
do you recommend putting...
--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 21, 2017 at 7:42 am

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

Jason A. Long - Monday, November 20, 2017 10:03 PM
The load order is far less interesting than the actual database names......
--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 11:38 pm

#1968947
RE: monitor when files get to 80%

myukas - Monday, November 20, 2017 6:58 PM
80% of max usage if a limit and possibly if unlimited growth and grows by...
--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 9:02 pm

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

Viewing 15 posts - 13,636 through 13,650 (of 59,095 total)