LutzM

Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 5,502 total)

RE: Create Excel File each time using SSIS

Maybe this link[/url] will provide the information you need.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 16, 2011 at 4:17 pm

#1299713
RE: Methods of speeding up a huge DELETE FROM <table>

tuseau (3/16/2011)
...
So, the reason I can't perform DDL statements or use truncate is because the application is being designed for concurrent transactions. Truncate will interfere, and obviously so...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 16, 2011 at 4:39 am

#1299262
RE: Creating nested xml tree

You don't have to post any actual data. Either make something up or use AdventureWorks tables that would describe your scenario. Once you have some sample data you should post...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 15, 2011 at 1:31 pm

#1299085
RE: Percentile Calculation on Frequency field

How many rows do you have in that table? And how many rows per Symbol (approximately)?
Reason for asking: This code performs a triangular join that might seriously influence performance...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 1:02 pm

#1298537
RE: Syntax Error!!Help

UPDATE
DWH_THE_ALLIANCE
SET
DWH_THE_ALLIANCE.SOLUTIONTYPE_LLAV_PR = 168
FROM DWH_THE_ALLIANCE t1
INNER JOIN DWH_TDI_SOLUTIONTYPE tsol ON t1.SOLUTIONTYPE_LLAV_PR = tsol.SOLUTIONTYPE_LLAV_PR
INNER JOIN DWH_TDI_OPPORTUNITY topp ON t1.OPPORTUNITY_LLAV_PR = topp.OPPORTUNITY_LLAV_PR
WHERE
topp.Status = 'WIN' AND
t1.TIME_LLAV_PR >= 20100701 AND
t1.SEBL_ID IN (
'CRMAP1-6-1DUXOPH'
) AND
t1.SOLUTIONTYPE_LLAV_PR = 155;

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 12:13 pm

#1298509
RE: Percentile Calculation on Frequency field

Ghanta (3/14/2011)
hehehe this is not that I am asking... recharge ur brain 🙂
What's wrong with my answer?

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 11:46 am

#1298493
RE: Percentile Calculation on Frequency field

I think you need the additional column to store the intermediate running toal values. To calculate those values, have a look at this post.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 11:24 am

#1298478
RE: Columns to Row?

LutzM (3/14/2011)
jason-772533 (3/14/2011)
I checked the 'Forums' list before I posted and couldn't see a 2K forum. I've just checked again and there isn't one listed. There is an 'Older versions'...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 11:14 am

#1298469
RE: Columns to Row?

jason-772533 (3/14/2011)
I checked the 'Forums' list before I posted and couldn't see a 2K forum. I've just checked again and there isn't one listed. There is an 'Older versions' forum...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 14, 2011 at 11:02 am

#1298458
RE: When not to like LIKE

If you run a LIKE '%something' statement against a table you'll end up with a table/index scan.
One option would be to add an indexed computed persisted column with REVERSE(ID). Then...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 13, 2011 at 2:46 pm

#1298147
RE: Columns to Row?

The concept still applies:
DECLARE @temp TABLE
(
Description_ CHAR(1),
Category VARCHAR(30)
)
INSERT INTO @temp
SELECT 'A','apple' UNION ALL
SELECT 'A','aardvark' UNION ALL
SELECT 'A','anteater' UNION ALL
SELECT...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 12, 2011 at 5:54 am

#1297997
RE: Columns to Row?

Please have a look at the CrossTab article referenced in my signature.
You might also continue with the DynamicCrossTab concept if you need even more flexibility.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 12, 2011 at 2:26 am

#1297985
RE: CASE statement to only show one day of the week

donato1026 (3/11/2011)
...
Sorry, but I won't be able to do that. This can be used on any database . . . it's just the case statement I am having an issue...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 11, 2011 at 3:26 pm

#1297913
RE: Creating nested xml tree

drew.allen (3/11/2011)
I'm not sure about other tools, but I've found that for creating complex XML structures using T-SQL, you're better off using FOR XML EXPLICIT instead of any of the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 11, 2011 at 3:02 pm

#1297904
RE: Creating nested xml tree

If you could provide some ready to use test data (as described in the first link in my signature) I could give it a try. (I'd like to test my...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

March 11, 2011 at 2:48 pm

#1297898

Viewing 15 posts - 1,756 through 1,770 (of 5,502 total)