Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,381 through 10,395 (of 59,095 total)

RE: The Number that shouldn't be a number

RonKyle - Thursday, December 13, 2018 12:41 PM
Eric M Russell - Thursday, December 13, 2018 12:19 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 13, 2018 at 1:39 pm

#2016261
RE: Need some help with some "XML Hell" please.

Eirikur Eiriksson - Monday, May 29, 2017 2:59 PM
Ed Wagner - Monday, May 29, 2017 2:40 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 10:54 pm

#2016181
RE: Get all Attributes from this XML

drew.allen - Wednesday, December 12, 2018 9:33 AM
info 58414 - Wednesday, December 12, 2018 8:24 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 12, 2018 at 9:00 pm

#2016178
RE: Interesting Use Case Of CEILING

Jonathan AC Roberts - Wednesday, December 12, 2018 4:16 PM
I think this might answer your question:
DECLARE @percentComplete float =...
--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 8:52 pm

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

PasLe Choix - Wednesday, December 12, 2018 7:37 PM
Lynn Pettis - Wednesday, December 12, 2018 9: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)

December 12, 2018 at 8:00 pm

#2016174
RE: Max Degree of Parallelism

lmalatesta - Wednesday, December 12, 2018 7:54 AM
Jeff Moden - Tuesday, December 11, 2018 6:19 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:54 pm

#2016173
RE: Invalid Parsename

chris geswein - Wednesday, December 12, 2018 9:52 AM
Jeff Moden - Wednesday, December 12, 2018 6:57 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 12, 2018 at 7:50 pm

#2016172
RE: Converting IO/s to MB/s

PHXHoward - Friday, October 12, 2018 3:02 PM
Hey everyone. We are looking at replacing a physical server with a VM and want...
--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:17 pm

#2016170
RE: Stuck Parallel Query

Adding a bit of a correction, it looks like the dupe-check goes a bit further. It also looks like the only time a particular group/invoice should be returned is 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 12, 2018 at 7:09 pm

#2016169
RE: Where Microsoft went wrong with SQL CLR

Steve Jones - SSC Editor - Saturday, January 17, 2015 11:04 AM
I actually think the CLR has worked well. MS used 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)

December 12, 2018 at 6:51 pm

#2016168
RE: Stuck Parallel Query

It appears to me that this is an attempt at the "simple" deduplication of data (Temp_Work is self joined) combined with a check for valid data (the <> 0 stuff). 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 12, 2018 at 6:24 pm

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

Viewing 15 posts - 10,381 through 10,395 (of 59,095 total)