Creating Indices on Temp Tables from Stored Procedures
-
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 -
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 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 -
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 -
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.
-
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 -
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 -
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
Viewing 8 posts - 46 through 53 (of 53 total)
You must be logged in to reply to this topic. Login to reply