Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,631 through 15,645 (of 59,063 total)

RE: Remove partitioning

As a bit of a sidebar, how much of the data is subject to change? Does the data in the table become totally static after some period of time? 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)

February 12, 2017 at 10:27 am

#1927995
RE: Remove partitioning

Indianrock - Saturday, February 11, 2017 5:49 PM
Thanks for the link. I'll dig into it ( scanned it last week ).
I understood...
--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 12, 2017 at 9:59 am

#1927994
RE: Is having a lookup table that is for multiple entities a common practice?

Doctor Who 2 - Saturday, February 11, 2017 6:54 PM
Jeff Moden - Thursday, February 9, 2017 9:41...
--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 12, 2017 at 9:48 am

#1927993
RE: Are the posted questions getting worse?

Sean Lange - Friday, February 10, 2017 1:16 PM
For that matter I am shocked at how many people are still creating...
--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 5:21 pm

#1927968
RE: Are the posted questions getting worse?

Michael L John - Friday, February 10, 2017 5:14 PM
With virtualized servers, less than 200 GB is not uncommon. We tend 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)

February 11, 2017 at 5:17 pm

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

I don't know enough about asp.net to tell you off the top of my head but the following search seems useful.
https://www.google.com/?gws_rd=ssl#q=match+asp.net+variables+to+sql+server+data+types
--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 5:11 pm

#1927966
RE: Remove partitioning

At a high level, all of the partitions must be merged to a single partition. All tables are "partitioned" in that they have a single partition.
I've not...
--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 5:06 pm

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

Viewing 15 posts - 15,631 through 15,645 (of 59,063 total)