Jeff Moden

Forum Replies Created

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

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
RE: Partitioning Data in a Multi-tenant Data Warehouse Solution

Sean Woehrle (4/22/2014)
Hello,
Most of our fact tables take under 5 minutes to run. We have about 6 truncate and reload fact tables. Then the switch...
--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 8:37 pm

#1707940
RE: SQL Server Maximum Write Performance

Grant Fritchey (4/22/2014)
Yeah, hard to argue with you Kevin (like it's ever easy). 8gb of RAM for SQL Server is probably barely adequate. My local VMs running on my laptop...
--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 5:49 pm

#1707934
RE: SQL Help requested to Get Daily and Weekly OT

DiabloZA (4/22/2014)
Hi Sean and MCX5000,
You guys are awesome, thank you for the queries, this is very helpful and timely especially for the crunch time that I'm in.
I ran 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)

April 22, 2014 at 5:34 pm

#1707932

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