Viewing 15 posts - 37,546 through 37,560 (of 39,818 total)
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
I agree with Brian in general. Coding on the fly leads you to forget things and make bad designs.
HOWEVER, I've been doing this a long time and a few things...
July 2, 2002 at 12:28 pm
If there are no indexes, it should insert in the same order, but SQL is not bound by this. Easiest way is to add a clustered index on the columns...
July 2, 2002 at 12:17 pm
How are you connecting? Are you a local admin?
Did you set an sa password? Are you using NT Auth or SQL Auth?
Steve Jones
July 2, 2002 at 12:13 pm
I created a sproc that creates a cursor from sp_who2 (or you can use sysprocesses) and kills each connection.
I usually run this before a restore a couple times. Some connections...
July 2, 2002 at 10:39 am
Similar to Andy. If it's something I've done, I'll probably just code.
If not, I'll probably outline some to be sure I won't forget anything and then fill in code. I...
July 2, 2002 at 10:35 am
The diff, I believe, flushes the logs, but I'm not sure. You'd ahve to test it and verify that you could restore (or not) using only the full and logs.
Steve...
July 2, 2002 at 10:33 am
Viewing 15 posts - 37,546 through 37,560 (of 39,818 total)