Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,131 through 32,145 (of 59,099 total)

RE: Help with performance - aggregating a lot of data

Kiara,
Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give the reporting performance you seek without interfering with...
--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)

October 29, 2011 at 10:20 am

#1400835
RE: Help with performance - aggregating a lot of data

Gah... Now that I've had time to look at it, I see that my problem with generating the test data was that not all usages of the Tally Table were...
--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)

October 28, 2011 at 4:20 pm

#1400800
RE: Help with performance - aggregating a lot of data

J Livingston SQL (10/28/2011)
Ok...got the test data now (dev machince at work 🙂 )
have you any performance figs...you say your query is "slow"...based on the test data what response...
--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)

October 28, 2011 at 12:42 pm

#1400761
RE: Help with performance - aggregating a lot of data

Nope. Good to go here. My only other question is how many rows does your test data jig create? I started it this morning in TempDB and...
--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)

October 28, 2011 at 11:47 am

#1400740
RE: Help - Reading data from row by row - without using cursor?

ananda.murugesan (10/28/2011)
Hi,
Table Name - EnergyMeter
Filed Name - Meter_Id
Total Records - 6
using stored procedure - how can read data for row 1, row 2, row 3 ...row 6.?
Thanks
ananda
For the information...
--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)

October 28, 2011 at 8:12 am

#1400640
RE: Convert column in multiple rows to a single csv column

CELKO (10/27/2011)
SQL Programmers do that kind of display formatting in the presentation layer and NEVER in the back end. Do you know what First Normal Form is (1NF) and...
--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)

October 28, 2011 at 8:09 am

#1400637
RE: Help with performance - aggregating a lot of data

How many rows does the real table have? And I probably missed it above but what is the actual DDL for this table and any indexes it may have?...
--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)

October 28, 2011 at 7:46 am

#1400628
RE: Set based Numbering process

Ah... I see. You've changed the rules a bit.
Take the code I previously posted and make it match where OT_ID and NT_ID are equal instead of matching on RestOfData.
--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)

October 27, 2011 at 7:47 pm

#1400470
RE: Please Help !!!!

Ninja's_RGR'us (10/27/2011)
Hey Jeff, actually "xxxxxxxxxxx@gmail.com" is a real mail :-D.
I guess we're running out of those too!
BWAA-HAAA!!!! Seriously? That's just unbelievable. What will someone think of next? 😀
--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)

October 27, 2011 at 7:36 pm

#1400467
RE: Are the posted questions getting worse?

Evil Kraig F (10/27/2011)
Seeking fresh Beer Popsicle suppliers. The Dust Bunnies have gone on strike until I stock up...
😀
--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)

October 27, 2011 at 7:26 pm

#1400466
RE: Are the posted questions getting worse?

Because a lot of Developers just want to get stuff off their plate, don't do peer reviews unless there's been some training as to what is expected in a peer...
--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)

October 27, 2011 at 7:22 pm

#1400464
RE: Restricting IMPERSONATE permissions only to certain stored procedures

You've made life entirely too difficult for yourself. 😉 Unless you're using xp_CmdShell, you shouldn't need a proxy user to do any of this. You don't need...
--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)

October 27, 2011 at 5:39 pm

#1400450
RE: Restricting IMPERSONATE permissions only to certain stored procedures

P.S. ... and no IMPERSONATE privs are required...
--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)

October 27, 2011 at 3:57 pm

#1400431
RE: Restricting IMPERSONATE permissions only to certain stored procedures

If the database is owned by SA, then "dbo" is actually "SA". Use EXECUTE AS OWNER within the proc and grant EXECUTE privs only to those users or roles...
--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)

October 27, 2011 at 3:56 pm

#1400430
RE: Are the posted questions getting worse?

jcrawf02 (10/26/2011)
what do you guys use for calendar apps?
My failing memory! 😛 The cool part about it is, I don't have to go to so many meetings that way....
--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)

October 26, 2011 at 11:10 pm

#1399986

Viewing 15 posts - 32,131 through 32,145 (of 59,099 total)