Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,451 through 39,465 (of 59,098 total)

RE: Enormous Tables - How to still get Best Performance

That's why I was asking "which edition"... IIRC, indexed views and partitioned tables (which I believe would also help here) are only available in the Enterprise Edition (understood they're also...
--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)

March 9, 2010 at 8:49 am

#1130721
RE: Concatenate column rows into one row with a group by

Ah... if it was a snake, it would have bitten me...
]--It is here where I would like to concatenate the ledger(s)[/i]
I'll have to take a look at this tonight.
--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)

March 9, 2010 at 8:46 am

#1130716
RE: Concatenate column rows into one row with a group by

I'm at work right now and might just be missing because I'm in a bit of a press for time, but how does what you just posted have anything 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)

March 9, 2010 at 8:44 am

#1130713
RE: Enormous Tables - How to still get Best Performance

Are you using the Enterprise or Standard Edition of SQL Server?
--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)

March 9, 2010 at 6:09 am

#1130584
RE: speed concerns for a large report

I believe that pre-aggregation would be one of the keys to speed here. Since you're running it as a job every 30 minutes, my suggestion would be to try...
--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)

March 9, 2010 at 5:31 am

#1130567
RE: Performance tuning

anishrtuladhar (3/8/2010)
Do performance tuning using SSAS....... when u need.:-D
Not sure what you mean. How do you performance tune a query using SSAS?
--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)

March 9, 2010 at 5:17 am

#1130564
RE: always use incorrect index to run the query by sql server

ColinChen (3/8/2010)
Thanks for everyone.
Now I found the issue:
Because the fieldB is varchar , and the fieldC is nvarchar.
select * from tableA where fieldB in(select fieldc from tablec)
If I alter 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)

March 9, 2010 at 5:15 am

#1130563
RE: Creating Temp Table with Avg

Nah... I was "Jonesin' " for a code problem instead of all the bloody performance problems we've had lately. Heh... I was on a "mission" on this one especially...
--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)

March 8, 2010 at 9:40 pm

#1130419
RE: What is the Best Practice of designing a table for storing a period of dates, Query for fiding the period

Ismail Ahmed (3/8/2010)
Hi Friends,
I have to add a table 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)

March 8, 2010 at 9:18 pm

#1130411
RE: Creating Temp Table with Avg

jrgustin 30365 (3/8/2010)
Hello,
I am trying to create a function that will produce an avg() for the selected results based on a string containing the digit of the filed ie(rda1)....
--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)

March 8, 2010 at 9:02 pm

#1130404
RE: Pivot table for dynamic data

Thanks for the referral, Paul.
--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)

March 8, 2010 at 7:29 pm

#1130377
RE: Unable to find table in the database

dohomebiz (3/8/2010)
I figured it out. thanks for your time.
So what was the problem? Might be helpful to other folks if we knew.
--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)

March 8, 2010 at 6:55 pm

#1130370
RE: Concatenate column rows into one row with a group by

MelissaLevitt (3/8/2010)
Jeff,
Your suggestion with the function almost worked except that I have to work with a temporary table and so I can't use the function.
I have been trying to avoid...
--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)

March 8, 2010 at 6:06 pm

#1130364
RE: SSIS Slower for Data Imports??

T-SQL_NewBie (3/8/2010)
Jeff Moden (3/7/2010)
T-SQL_NewBie (3/4/2010)
I have been told by my manager that SSIS 2008 is slower than Hibernate for data migration, apparently because of cache problems..how do I reason that...
--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)

March 8, 2010 at 5:47 pm

#1130362
RE: XP_CMDSHELL

cfradenburg (3/8/2010)
Check what @@servername returns. If the server got renamed that may not be the actual name of the server. The following will get the current name that...
--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)

March 8, 2010 at 5:27 pm

#1130359

Viewing 15 posts - 39,451 through 39,465 (of 59,098 total)