LutzM

Forum Replies Created

Viewing 15 posts - 3,766 through 3,780 (of 5,502 total)

RE: How to tune/speed up a procedure

gregory.anderson (4/16/2010)
That example of the cross apply stuff makes it look so easy. Once the article mentioned it was just like a method in programming, it kind of clicked for...

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]

April 16, 2010 at 10:04 am

#1152983
RE: Problem in INSERT statement :(

Chris Morris-439714 (4/16/2010)
...
This is what happens when you moonlight as a shower-curtain salesman, Lutz 😛
...
Are you not satisfied working with SQL anymore? And do you sell knifes as well wearing...

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]

April 16, 2010 at 9:42 am

#1152956
RE: Optimization: Turning a series of entries into columns

huston.dunlap (4/15/2010)
That would work, with the only note that it tremendously increases the amount of CASE statements I need.
Because every entry is now unique to every record, the number of...

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]

April 16, 2010 at 9:38 am

#1152952
RE: Finding Multiple ProductCodes

If there is the need to store more than 8 products, I'd question the purpose of CustomerWithMultipleProducts, too.
In that case I'd most probably use that table to store the unique...

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]

April 15, 2010 at 4:52 pm

#1152514
RE: Issue with Stored Procedure

kwitzell (4/15/2010)
thanks for the reply,
The collation is: SQL_Latin1_General_CP1_CI_AS
I will have to look for a case issue...
The CI stands for CaseInsensitive. Otherwise you'd have a CS collation. No need for further...

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]

April 15, 2010 at 4:45 pm

#1152513
RE: Finding Multiple ProductCodes

If the data need to be stored in the intermediate table in separate columns I'd use the CrossTab approach as described in the related link in my signature.
But if 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]

April 15, 2010 at 4:30 pm

#1152506
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/15/2010)
lmu92 (4/15/2010)
But to make sure you're still able to read what you wrote as the "upper limit" and "enough to help the ideas flow freely" as the "lower limit"...

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]

April 15, 2010 at 4:15 pm

#1152502
RE: Look at everything, change nothing

Based on what you just wrote I would insits on getting a special role to be set up by the vendor to meet your requirements.
It should benefit "both sides". I...

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]

April 15, 2010 at 4:10 pm

#1152501
RE: Are the posted questions getting worse?

Alvin Ramard (4/15/2010)
Roy Ernest (4/15/2010)
What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to...

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]

April 15, 2010 at 3:53 pm

#1152494
RE: Look at everything, change nothing

David Webb-200187 (4/15/2010)
Yes, it's a strange position to be in. I just found out that the outsourcer, who shall remain nameless, was paid to migrate some databases from SQL...

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]

April 15, 2010 at 3:22 pm

#1152481
RE: How to tune/speed up a procedure

Well, Wayne, I appreciate the compliment :blush:
But it looks much more complicated than it really is:
Those "x"hundred lines of code include quite a few descriptive comments (which is, to be...

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]

April 15, 2010 at 3:05 pm

#1152463
RE: How to tune/speed up a procedure

WayneS (4/15/2010)
lmu92 (4/15/2010)
blah blah blah.... Right, Wayne?
uh, sure, jeff :w00t:
You consider my statement as "blah blah blah"? I'm depressed now. :crying:

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]

April 15, 2010 at 2:16 pm

#1152427
RE: Problem in INSERT statement :(

@chris-2: When did you start promoting loops??? :crying:
Or do I miss something that prevent doing it set based?

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]

April 15, 2010 at 2:12 pm

#1152424
RE: Look at everything, change nothing

David Webb-200187 (4/15/2010)
I'm in a position now where I am managing an outsorced DBA service. I'd like to be able to look at everything at the server and database...

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]

April 15, 2010 at 2:01 pm

#1152418
RE: Optimization: Turning a series of entries into columns

Even if I'm not Jeff ( 😀 ) but promoting his great articles because those are simply the best ones I found related to this subject, I'd use ROW_NUMBER() to...

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]

April 15, 2010 at 1:42 pm

#1152409

Viewing 15 posts - 3,766 through 3,780 (of 5,502 total)