Viewing 15 posts - 49,051 through 49,065 (of 49,571 total)
or you can use the datalength function, which can be used on text fields
August 16, 2006 at 1:16 am
The SQL 2005 books online conain a lot of information for beginners. The sections on create procedure, insert statements, update statements and if - else statements will probably be of most...
August 11, 2006 at 5:35 am
Are you maybe trying to do this?
Select sum(cast(ISNULL(Hedonic_Value,0) as bigint)) as SumHedonic, sum(cast(sa_sqft as bigint)) as sa_sqft,
sa_census_tract, sa_census_block_group, count(*) as totalHomes, 'B' as HouseType
From ReplyAVM
Where isnull(sa_sqft, 0)...
August 11, 2006 at 5:31 am
I would agree on the job, but not on the cursor. From the sounds of things, the updates can be done set-based.
August 11, 2006 at 1:24 am
> 3 or 4 times faster (according to your own tests) is not significant difference for you?
As you said, is 3 ms worth the effort. If it was 3 min vs 1...
August 10, 2006 at 11:49 pm
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
Viewing 15 posts - 49,051 through 49,065 (of 49,571 total)