Jeff Moden

Forum Replies Created

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

RE: Log file R drive- What is consuming it

coolchaitu - Tuesday, November 21, 2017 10:45 PM
Jeff Moden - Monday, November 20, 2017 4:00 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 22, 2017 at 6:14 am

#1969154
RE: Force execution plan in a view

Luis Cazares - Monday, November 20, 2017 7:27 AM
I'm having an issue right now. We removed an identity column that is mostly...
--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 9:55 pm

#1969117
RE: Force execution plan in a view

Hmmm... I haven't tried it but perhaps a BIGINT Sequence would work here.
--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 9:10 pm

#1969114
RE: Force execution plan in a view

Put the IDENTITY column back on the table and call it a day. It wasn't as irrelevant as everyone thought.
--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:53 pm

#1969113
RE: Choosing the Birthday of a Customer by month?

If finding rows by birth month without regard to year or day is something important, it's probably worthwhile to materialize the birth month in the table using a persisted computed...
--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:46 pm

#1969112
RE: Slow query - client or server issue

It sounds like a classic case of the bad kind of parameter sniffing. My first step on something that handles that many rows would be to add OPTION (RECOMPILE) to...
--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:59 pm

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

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