Creating Indices on Temp Tables from Stored Procedures

Question

Creating Indices on Temp Tables from Stored Procedures

Viewing 8 posts - 46 through 52 (of 52 total)

You must be logged in to reply to this topic. Login to reply

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

Jeff Moden (4/7/2010)
kramaswamy (4/6/2010)
I think that it could be an interesting summer job for an intern,...
Heh... summer intern evaluating code for performance problems. I believe that probably won't help.
...because you're going to have nothing concrete to demonstrate for your efforts.
I always have something concrete in this area because I always do a "Before'n'After" set of tests and measurements. You can bet consultants like Kevin do...

BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Paul White SSC Guru Points: 150467 More actions · Answer 2

TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎

Superb.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.

And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

TheSQLGuru (4/7/2010)
Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.
And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe

Most excellent. Only problem is I need it to provide the Left() output.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Garadin One Orange Chip Points: 29613 More actions · Answer 5

CirquedeSQLeil (4/7/2010)
TheSQLGuru (4/7/2010)
Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.
And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe
Most excellent. Only problem is I need it to provide the Left() output.

The booming chorus of rimshots probably just woke a few babies.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 6

CirquedeSQLeil (4/7/2010)
TheSQLGuru (4/7/2010)
Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.
And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe
Most excellent. Only problem is I need it to provide the Left() output.

Not my problem - that's a front-end formatting issue!! 😛

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Garadin (4/7/2010)
CirquedeSQLeil (4/7/2010)
TheSQLGuru (4/7/2010)
Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.
And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe
Most excellent. Only problem is I need it to provide the Left() output.
The booming chorus of rimshots probably just woke a few babies.

:-D;-)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

TheSQLGuru (4/7/2010)
CirquedeSQLeil (4/7/2010)
TheSQLGuru (4/7/2010)
Paul White NZ (4/7/2010)
TheSQLGuru (4/7/2010)
BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎
Superb.
And before someone jumps on my omission I will add that I KNOW it will give the RIGHT OUTPUT too!! hehehehehe
Most excellent. Only problem is I need it to provide the Left() output.
Not my problem - that's a front-end formatting issue!! 😛

I better go find that gooey developer then.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events