Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,791 through 23,805 (of 59,102 total)

RE: Issue with specific table accessing having Performance issue

I, of course, can't tell for sure but your PK looks pretty well hosed. Is, for example, ActID ever increasing? Why is it a VARCHAR(50)? Is ActID, 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)

April 23, 2014 at 9:25 pm

#1708293
RE: Pulling incorrect records using date range in where clause

below86 (4/23/2014)
Lynn Pettis (4/23/2014)
below86 (4/23/2014)
Wouldn't it be better to use the BETWEEN with these dates?
WHERE (ath_postype = 'NTC' OR ath_postype='NTD')
AND ath_postdate BETWEEN '2013-01-01 00:00:00.000' ...
--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)

April 23, 2014 at 9:20 pm

#1708292
RE: Help me out

BWAAA-HAAAA!!!! And now I see the question of the day is exactly what you're looking up?
Please drive through. 😉
--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)

April 23, 2014 at 8:54 pm

#1708290
RE: Need to generate Report from a Busy Database

karthik babu (4/22/2014)
Hi All,
We have a production database which is busy throughout the day and need to generate report from the same. The tables undergoing inserts/updates will be used 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)

April 23, 2014 at 8:50 pm

#1708289
RE: Help me out

My first question is... do you actually have a problem where Hekaton would actually solve the problem? Hekaton is not a performance panacea.
--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)

April 23, 2014 at 8:46 pm

#1708288
RE: Problem with concurrent insert into a partitioned table

Do you have any other indexes on the table? If so, are the "aligned" with the partitions?
--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)

April 23, 2014 at 8:42 pm

#1708287
RE: Table size not reducing after large data delete and index rebuid

S_Kumar_S (4/23/2014)
Jeff
replying to your questions:
1.This table is more like your OrderDetail table. There might be some updates daily but very few records (may be less than 50) get updated daily.
2.I...
--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)

April 23, 2014 at 12:46 pm

#1708236
RE: Partitioning Data in a Multi-tenant Data Warehouse Solution

Sean Woehrle (4/23/2014)
For now I don't want to change the 20 packages that use this approach. We have looked at parameterizing the packages further or generating them from metadata...
--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)

April 23, 2014 at 12:37 pm

#1708232
RE: Table size not reducing after large data delete and index rebuid

Ok... let's shift gears here a bit.
This is a 160GB table and there are several types of performance and space savings that many may not have considered. Before I...
--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)

April 23, 2014 at 8:27 am

#1708133
RE: Weekly Best Seller

I agree with JLS above. Please help us help you. See the article at the first link in my signature line below under "Helpful Links" for what we're...
--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)

April 23, 2014 at 8:15 am

#1708125
RE: Partitioning Data in a Multi-tenant Data Warehouse Solution

N_Muller (4/23/2014)
A third option with zero downtime is to create your partitioned table with extra partitions. You simply need a small table-of-contents (TOC) table that has as many rows as...
--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)

April 23, 2014 at 8:07 am

#1708115
RE: Partitioning Data in a Multi-tenant Data Warehouse Solution

Sean Woehrle (4/23/2014)
Jeff,
I always appreciate a better way to do things, so your suggestions are welcome.
I think we are basically "staging the full replacement" for customer 1 in the article...
--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)

April 23, 2014 at 8:00 am

#1708111
RE: Calendar Tables

Heh... the Tally table took one on the chin in this article and, after 3 1/2 years (hopefully, that's long enough to not detract from a valuable article written 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)

April 23, 2014 at 1:13 am

#1707970
RE: Consolidation Matters

marcia.j.wilson (4/21/2014)
Jeff Moden (4/21/2014)
Heh... this reminds me of hemlines in fashion. They change every other year.
Remember when distributed computing was all the rage? It wasnt' that long ago....
--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)

April 22, 2014 at 11:23 pm

#1707954
RE: Are the posted questions getting worse?

Brandie Tarvin (4/22/2014)
Jeff Moden (4/22/2014)
ChrisM@Work (4/22/2014)
The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would...
--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)

April 22, 2014 at 11:17 pm

#1707951

Viewing 15 posts - 23,791 through 23,805 (of 59,102 total)