Viewing 15 posts - 37,441 through 37,455 (of 39,720 total)
You're welcome and glad it worked.
Steve Jones
July 3, 2002 at 2:45 pm
You'd have to check through them. Somewhere down the line, I suspect that the table is being altered in some way. Is this with a temp table?
Steve Jones
July 3, 2002 at 12:32 pm
Does this happen everytime?
Can you post the table DDL and the stored proc?
Steve Jones
July 3, 2002 at 10:18 am
You need a system datasource. The SQL package runs under the SQLAgent account, which will not see your user DSN.
Steve Jones
July 3, 2002 at 10:17 am
Introduction: State what this is (current config, perform analysis and recommendations)
Current Config: Do hardware and software. SQL config, database physical layout. Server settings, backup plan, etc.
PErformance: Run some numbers, profiler,...
July 3, 2002 at 10:15 am
You'd have to test this. On the surface, I'd say yes, but the time creating the checksum may not outweigh the comparison time. SQL can be pretty fast at comparisons.
Steve...
July 3, 2002 at 10:11 am
The clustered index will eventually be used, either directly or with a bookmark lookup since it contains the data. However the actual choice depends, as Andy says, on the query...
July 3, 2002 at 10:10 am
Not sure how you could do this. Maybe cast the column and see if that removes the collation?
Steve Jones
July 3, 2002 at 10:08 am
If no identity or other colum you could institute a subquery and join
oi.datetime = ( select min( o3.datetime)
...
July 3, 2002 at 10:07 am
Brian's method is the only way. You cannot remove an identity column.
Steve Jones
July 3, 2002 at 10:05 am
I'd say make a PK, but it's hard to know. If you want to ensure there is uniqueness with the 3 fields, then it should be a PK.
Steve Jones
July 3, 2002 at 10:04 am
cast( col as int) in the order by. This will move 1,10,2 to 1,2,10.
If this is the second character (and beyond)
cast( substring( col, 2, 10) as int)
Steve Jones
July 3, 2002 at 10:02 am
Tend to agree. you can connect with another instance or QA and run sp_who2 a few times and check that your other connection is still processing.
Steve Jones
July 3, 2002 at 9:59 am
select @cmd = 'kill ' + @spid
exec(@cmd)
Steve Jones
July 2, 2002 at 4:26 pm
Have you checked the query plan?
An alternative is to "batch" the updates:
http://www.sqlservercentral.com/columnists/sjones/batching.asp
Steve Jones
July 2, 2002 at 12:59 pm
Viewing 15 posts - 37,441 through 37,455 (of 39,720 total)