Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,396 through 10,410 (of 59,099 total)

RE: How can I combine the three queries to one and possibly improve performance

PasLe Choix - Wednesday, December 12, 2018 7:25 AM
Jeff Moden - Tuesday, December 11, 2018 6:08 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)

December 12, 2018 at 7:44 am

#2016096
RE: Invalid Parsename

chris geswein - Monday, December 10, 2018 10:44 AM
Steve Jones - SSC Editor - Monday, December 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)

December 12, 2018 at 6:57 am

#2016088
RE: Need help using a variable in the following statement

shackclan - Wednesday, December 12, 2018 5:06 AM
Jeff,
I stand corrected. Old dogs and new tricks.
create table #tmp
(
number int
)
insert into #tmp...
--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)

December 12, 2018 at 6:46 am

#2016086
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

After you've done that, automate the creation of a new file/filegroup for a new "next" month and the auto-magic rebuild of the partitioned view.
Another cool part is that, if...
--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)

December 11, 2018 at 10:07 pm

#2016061
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

You're on the right track with separate files and file groups.
If the data is static after being loaded, then base your files and file groups so that...
--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)

December 11, 2018 at 10:04 pm

#2016060
RE: Very strange execution plan estimated rows was really large

Without being able to see the rest of the execution plan nor have the execution plan where we can drill into the properties of each node, it's likely to remain...
--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)

December 11, 2018 at 6:36 pm

#2016055
RE: Need help using a variable in the following statement

jonathanm 4432 - Tuesday, December 11, 2018 7:03 AM
I have the following statement and I need to use a variable like so:
declare...
--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)

December 11, 2018 at 6:32 pm

#2016054
RE: Need help using a variable in the following statement

shackclan - Tuesday, December 11, 2018 7:54 AM
Problem is that your temp table #price is local. It will not be in scope...
--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)

December 11, 2018 at 6:29 pm

#2016053
RE: Where did our 30GBs go?

ScottPletcher - Tuesday, December 11, 2018 11:15 AM
scarr030 - Tuesday, December 11, 2018 10:49 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)

December 11, 2018 at 6:23 pm

#2016052
RE: Max Degree of Parallelism

lmalatesta - Tuesday, December 11, 2018 12:41 PM
It's also one of the first settings I change whenever someone asks me to tune...
--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)

December 11, 2018 at 6:19 pm

#2016051
RE: How can I combine the three queries to one and possibly improve performance

PasLe Choix - Tuesday, December 11, 2018 6:06 PM
ScottPletcher - Tuesday, December 11, 2018 2:47 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)

December 11, 2018 at 6:08 pm

#2016050
RE: How can I combine the three queries to one and possibly improve performance

PasLe Choix - Tuesday, December 11, 2018 12:57 PM
OK, thank you guys but I doubt none of the replies catched it.
As indicated...
--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)

December 11, 2018 at 5:59 pm

#2016048
RE: Stuck Parallel Query

Not nearly enough information. My recommendation is to download a copy of sp_WhoIsActive by Adam Machanic (Google for it, please) and find out what is running (it'll show the actual...
--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)

December 11, 2018 at 5:24 pm

#2016045
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

Maybe if I ask a third time... 😉
You say the last batch caused the file to grow so let's talk about the nature of your batches vs the rest 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)

December 11, 2018 at 5:01 pm

#2016042
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

Jeff Moden - Thursday, November 22, 2018 1:56 PM
bdkdavid - Wednesday, November 21, 2018 5:37 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)

December 11, 2018 at 3:20 pm

#2016037

Viewing 15 posts - 10,396 through 10,410 (of 59,099 total)