LutzM

Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 5,502 total)

RE: CTE/View definition

Use ISNULL() to assign a non-NULL value?? :ermm:

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]

July 4, 2011 at 8:16 am

#1347877
RE: Performance tunning for query

arvind.1611 (7/4/2011)
creating non-clustered index on main_detail(unqkey,line_nbr) should help..
Are you aware that we're talking about a table with more than a billion rows and such an index would only be required...

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]

July 4, 2011 at 7:21 am

#1347835
RE: Performance tunning for query

vinod.saraswat (7/4/2011)
Hi All,
Datatype for both the cols are int and allow null as it is a source for the ETL developement. UNQKEY will remail unique i.e. not null once 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]

July 4, 2011 at 3:59 am

#1347712
RE: How to get SUM of Current day amount minus SUM of Previous day amount

Please provide table def and sample data in a ready to use format as described in the first link in my signature.
Also, please include your expected result based on your...

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]

July 4, 2011 at 2:06 am

#1347658
RE: Performance tunning for query

It's not the ORDER BY by itself causing the long duration.
It's the combination of TOP x ORDER BY.
In order to find the top 10 rows all rows need 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]

July 4, 2011 at 2:04 am

#1347656
RE: Inventory Stock Report Stored Procedure - Urgent Help

What have you tried so far and where did you get stuck?
Your request that we should write the stored procedure for you is quite demanding.... We're here to assist you,...

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]

July 3, 2011 at 3:28 pm

#1347567
RE: parallel execution of a stored proc?

Just a warning: Depending on how the proc is written you may end up with heavy locking, blocking or even deadlocking if running the code in parallel. This may cause...

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]

July 1, 2011 at 11:58 am

#1347245
RE: Unnecessary Index?

Syed Jahanzaib Bin hassan (7/1/2011)
Dont use Clustered index column in the NonClustered index this is overhead and leaf level of this nonclustered index will be same as your index when...

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]

July 1, 2011 at 11:02 am

#1347202
RE: Stored Procedures with multiple options using an @action parameter

I second opc.three.
In the scenario you describe I might use a "master proc" with the general structure as shown.
Depending on the logic inside each IF block I'd either have...

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]

July 1, 2011 at 10:31 am

#1347162
RE: Column Delete Issue

30k rows are not that much by just looking at the number itself. It depends on how frequent the table is queried and how many indexes are in place. If...

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]

July 1, 2011 at 10:18 am

#1347154
RE: Using SET DATEFIRST 1 (Monday as day 1 )

Assuming you're looking for the ISO week number the DATEFIRST approach won't help you at all. The ISO week number depends on the weekday of January 1st.
Since you're using SS2K5...

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]

July 1, 2011 at 10:03 am

#1347141
RE: Unnecessary Index?

The classic answer: "It depends" 🙂
INDEX_2 might be chosen by a query since it's more narrow than the original table. But since there are only two more columns (8 byte...

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]

July 1, 2011 at 9:53 am

#1347135
RE: case statement in a where clause

You could change the query to to
AND psf.assetRegion_ID >= @assetregion_id_min
AND psf.assetRegion_ID <= @assetregion_id_max
set @assetregion_id_min to 1, 2 or @assetRegion_ID and
@assetregion_id_max to 2147483647 (max value for an INT data type)...

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]

July 1, 2011 at 9:39 am

#1347123
RE: I am getting this error msg : Invalid length parameter passed to the LEFT or SUBSTRING function.

Just go to the Line 155 of Procedure axspRSTOCKLEDGERREPORT as indicated by the error message.
Somewhere in that area is either a LEFT or SUBSTRING function (also mentioned in the error...

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]

July 1, 2011 at 4:18 am

#1346932
RE: Problem with Cross Tab Query collecting all required Data

please provide table def and sample data in a ready to use format as described in the first link in my signature.
You might also want to have a look at...

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]

June 29, 2011 at 2:42 pm

#1346244

Viewing 15 posts - 1,336 through 1,350 (of 5,502 total)