Viewing 15 posts - 3,901 through 3,915 (of 6,216 total)
Uncheck the repair errors box in the maint plan. If you find errors then you can go back and set single user mode and manually run the dbcc checkdb with...
July 2, 2002 at 8:01 am
Depends on the scope. For situations that Im entirely comfortable (or pretty close) I'll just write the code. If its new, convoluted, etc, I'll work something out first, either by...
July 2, 2002 at 5:52 am
Thanks for the comments so far, didnt know what reaction to expect! David one note, MS in its wisdom is moving away from Hungarian in .Net.
Andy
July 2, 2002 at 5:51 am
Its true that if you're opening and closing the connection its hard to check to see who is in the db - sp_who is only a snapshot at the moment...
July 1, 2002 at 3:25 pm
July 1, 2002 at 11:37 am
July 1, 2002 at 5:59 am
Either do a transaction log backup or increase the size of your transaction log, or change it to truncate on checkpoint/simple mode.
Andy
July 1, 2002 at 4:08 am
Good article. In particular the point about putting spaces in so that you can jump from word to word easily is one often overlooked.
Andy
June 30, 2002 at 9:00 pm
You can just run an update inside your trigger that looks something like this:
update colname=null where pkey in (select pkey from inserted where colname=0)
I dont know that the conditional update()...
June 30, 2002 at 11:36 am
June 29, 2002 at 10:24 am
I'd agree that the case statement is probably the cleanest translation. One way would be like this:
declare @test-2 int
set @test-2=1
select case when @test-2=1 then 'true' else 'false' end
Depending on what...
June 29, 2002 at 5:39 am
Thats correct. All the "2" objects have additional SQL2K functionality. They've preserved the original interface so that existing code didnt break.
Andy
June 29, 2002 at 5:30 am
Hey Dan,
Not sure its a big space saver - doesnt SQL handle bits like nulls internally, uses one byte to store 8 values? Dont have my Inside SQL book handy...
June 28, 2002 at 10:20 am
First you have to decide what constitutes an update. If a user updates the column to the same value the Update() syntax will still be true. A better choice is...
June 28, 2002 at 5:40 am
Take a look at BOL - DBCC Shrinkfile using the Emptyfile parameter, I think it will be a better solution than detach/attach.
Andy
June 28, 2002 at 4:24 am
Viewing 15 posts - 3,901 through 3,915 (of 6,216 total)