Viewing 15 posts - 49,051 through 49,065 (of 49,566 total)
No, the gain is not really worth anything.
Except the question was how does the performance of the two compare. Answer, almost the same, no significant difference
August 10, 2006 at 6:25 am
I can't help you tune the query if I don't know what the underlying structure is like. Can you at least post the text execution plan and the row counts...
August 10, 2006 at 3:57 am
Please post the structure of the tables, the indexes on those tables and the number of rows in the tables.
Also please post the text execution plan. you can get that...
August 10, 2006 at 3:29 am
Check your joins, it may be that you have unintentional cross joins. Otherwise work out why you have duplicate rows and fix the source of the problem, don't fix the...
August 10, 2006 at 2:30 am
Could you post the structure of the tables, the indexes and the aprox rowcount that we're dealing with here?
How long does the current query take to run?
August 10, 2006 at 2:24 am
Sergiy, if you're not going to say anything useful, why bother posting at all?
I didn't check BoL, but I tested it out on a large table that I have:
August 10, 2006 at 2:17 am
If you create the #Temp in the outer, it will be available to the two subprocedures.
August 8, 2006 at 5:39 am
I've had a similar problem before. It may have to do with procedure caches and compiling.
Try splitting the stored proc into 3. The main stored proc does a check of...
August 8, 2006 at 2:13 am
That's possible, but very much not recommended.
You can't create triggers on system tables (like syscomments) so to do that, you have to convince SQL that the syscomments table is...
August 7, 2006 at 9:20 am
If you're using SQL 2005, you can put a DDL trigger on the database to catch ALTER PROCEDURE statements.
You can do a checksum over the syscomments table for each stored...
August 3, 2006 at 12:29 am
It's generally reomended that sub queries go in the from clause, not in the select. Sub queries in the select get evaluated for every row of the result set and...
August 1, 2006 at 12:25 am
July 31, 2006 at 3:09 am
Where I live the term 'postal service' is a joke. It's more postal non-service Stuff takes a week or 2 weeks to get from one city to another (50km apart)....
July 28, 2006 at 2:20 am
It may also be that the indexes are fragmented. Performance degrades as indexes get more fragmented and it may be that recently the fragmentation reached a point where the query...
July 28, 2006 at 1:14 am
You can use a trigger to log inserts, updates and deletes. There's no way to audit selects though, not within SQL directly. Books online gives a good overview of trigger...
July 28, 2006 at 1:02 am
Viewing 15 posts - 49,051 through 49,065 (of 49,566 total)