LutzM

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 5,502 total)

RE: Help with query !!!

There's nothing to indicate "the latest one".
The workaroud Chris had to use might not guarantee the correct output each time.
You should define for yourself what "latest one" should be 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]

August 6, 2014 at 6:03 am

#1735596
RE: Difference In Query Plans while Executing Same Query Independently and Within Stored Proc

Without seeing the queries and the actual execution plans it's just guessing...
So, my guess would be parameter sniffing.
For a more detailed answer please provide both, the stand-alone query as well...

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]

August 6, 2014 at 5:54 am

#1735588
RE: Open Query to Oracle

Yes, the 2nd option is used when there's a need to send data from a SQL source to an Oracle target.

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]

August 6, 2014 at 5:48 am

#1735583
RE: Open Query to Oracle

If both tables (Old_item and new_ITEM) are located at Oracle you could use
Execute ('insert into Old_item
...

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]

August 6, 2014 at 2:34 am

#1735525
RE: Table size is Huge!!!

Here are a few options to make that single table "smaller":
If the table contains a rather large number of columns (e.g. 50 or more) you might consider "vertical partitioning", meaning...

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]

August 6, 2014 at 2:22 am

#1735523
RE: XML parsing Error..

without seeing the code or at least the xml (obfuscated if needed) and a description how the xml is generated, any answer would be just guessing...
My guess: either the XML...

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]

August 6, 2014 at 2:11 am

#1735519
RE: How to send a mail alert on field value change in Table with both value old one and changed on

Yes.
If you followed best practice to allow data change by external applications only via stored procedures you could add the OUTPUT clause to the UPDATE statement together with the internal...

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]

August 4, 2014 at 2:31 am

#1734753
RE: indexing a table having million of records

@tom:
My answer (Yes) is based on the "question":
...my indexing will help on this table or should I create index in some other way to optimise performance...
which is close to "it...

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]

August 3, 2014 at 5:47 pm

#1734711
RE: indexing a table having million of records

To be a little more serious:
To add an index depends if there are queries that'll benefit from it.
Adding an index with all columns just because of adding the index doesn't...

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]

August 3, 2014 at 8:38 am

#1734684
RE: Are the posted questions getting worse?

Lynn Pettis (8/3/2014)
Eirikur Eiriksson (8/3/2014)
Where was that Crystal Ball again when one needs it, certain I've seen it somewhere...
😎
Actually, I think the Crystal Ball is needed here. I just...

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]

August 3, 2014 at 8:13 am

#1734682
RE: indexing a table having million of records

after a semi-internal discussion the answer we agreed on is:
Yes.
If you need a more detailed answer please provide a more detailed question.

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]

August 3, 2014 at 8:13 am

#1734681
RE: Using Views

I've been in a project until recently where we had to develop a new database interacting with several applications.
At the beginning it was just me who advocated against the plan...

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]

August 3, 2014 at 7:59 am

#1734678
RE: How to replace null value in a query

Again: please clarify what you mean by "Null values"!
The best was to explain it is to provide ready to use sample data as described in the first link in 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]

August 3, 2014 at 6:26 am

#1734669
RE: How to replace null value in a query

This thread is an excellent example of "logic guessing" because of missing sample data. :angry:
I didn't consider the option that an empty column would be represented by the string 'NULL'...

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]

August 3, 2014 at 6:13 am

#1734667
RE: How to replace null value in a query

Sorry for the wrong term "error".
When running the code I posted I get the expected result you're looking for.
So, to rephrase my response:
Running the code I posted I get 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]

August 3, 2014 at 4:56 am

#1734659

Viewing 15 posts - 136 through 150 (of 5,502 total)