Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,676 through 15,690 (of 59,101 total)

RE: Remove partitioning

I'd just like to remove partitioning and consolidate the files/filegroups into Primary
I have to ask, why? What's wrong with it the way it is? What advantage...
--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)

February 11, 2017 at 1:35 pm

#1927960
RE: What is perfect way to declare variable data type in asp.net to match SQL data type?

IMHO, call a stored procedure.
--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)

February 11, 2017 at 1:33 pm

#1927959
RE: Roll up of % and duration to Parent from Child

I did, finally, get to what the columns were for the parent/child relationship in that previous thread and made it work for the OP (heh... until he changed it). 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)

February 11, 2017 at 12:22 pm

#1927956
RE: Did you ever see a change of a collation change drastically a performance of a query?

p.s. As a bit of a sidebar, do notice that the server actually did more work (CPU) than with the original collation. All other info being absent, it does appear...
--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)

February 11, 2017 at 11:57 am

#1927953
RE: Did you ever see a change of a collation change drastically a performance of a query?

FabricioLimaDBA - Thursday, February 9, 2017 4:58 AM
Hi Guys,
Did you ever see a change of a collation change drastically a performance...
--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)

February 11, 2017 at 11:51 am

#1927951
RE: trouble wit a poor performing query

gvoshol 73146 - Thursday, February 9, 2017 5:21 AM
Jeff Moden - Tuesday, February 7, 2017 5: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)

February 11, 2017 at 11:42 am

#1927950
RE: Best way to determine to Clustered index keys

JasonClark - Thursday, February 9, 2017 10:24 PM
Bulk recovery
--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)

February 11, 2017 at 9:59 am

#1927946

RE: Query works until I use it in a stored procedure (contains forward slash)

Lynn Pettis - Thursday, February 9, 2017 4:42 PM

pharmkittie - Thursday, February 9, 2017 4:11 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)

February 11, 2017 at 9:49 am

#1927945