Viewing 15 posts - 91 through 105 (of 242 total)
I think this will depend on a number of factors, but it is certainly bad practice.
After an error I'd expect to exit from this stored procedure with a warning message...
July 21, 2009 at 7:24 am
Suresh B. (7/21/2009)
Page density is very low at 19%, which seems to be tie up with the issue, so any ideas why this would occur on a table that is...
July 21, 2009 at 7:20 am
It's because it's a non clustered index.
Updates on a non clustered index can effectively be a delete and an insert - on a non clustered index the data is deleted...
July 21, 2009 at 7:18 am
mayur.patel, there is a highly relevant point in your original post
mayur.patel (7/19/2009)
Also database Recovery model is Simple.
If the recovery mode is simple you do not have to schedule transaction log...
July 21, 2009 at 2:26 am
vliet (7/15/2009)
July 15, 2009 at 9:37 am
Steve, great article written to provoke debate, and it has.
I think you're right, but would add a couple of other reasons why.
First, the business users who define the specification don't...
July 15, 2009 at 8:52 am
Its a common misconception that it's a good idea to shrink the transaction log. If you do, it will just grow again.
If you have backups every 15 minutes, that's fine....
July 9, 2009 at 5:49 am
GilaMonster (6/25/2009)
Tim Walker (6/25/2009)
June 25, 2009 at 10:49 am
GilaMonster (6/25/2009)
Tim Walker (6/25/2009)
Additionally I am guessing it uses the index based on the varchar(3) column because it occupies less pages than the varchar(15) one.
Depending, of course, on the size...
June 25, 2009 at 9:48 am
Additionally I am guessing it uses the index based on the varchar(3) column because it occupies less pages than the varchar(15) one.
🙂
Tim
June 25, 2009 at 9:05 am
You have included it - you just didn't realise!
Where you have a unique clustered index or primary key an index uses this to point to the data. Your example makes...
June 25, 2009 at 9:03 am
It's also worth noting that if there is a choice of covering indexes that can be used to return the results, the one occupying the smallest number of pages is...
June 25, 2009 at 5:09 am
The following two statements are both true and do not contradict each other.
(Gails point) The order in which you perform disk defragmentation / internal defragmentation will make no difference to...
June 17, 2009 at 1:57 am
GilaMonster (6/11/2009)
Tim Walker (6/10/2009)
June 11, 2009 at 5:35 am
Excellent article. Very comprehensive about the theory!
Question: (and I wouldn't have even asked it if I hadn't read this first) is what is the point in defining a unique constraint...
June 10, 2009 at 4:31 pm
Viewing 15 posts - 91 through 105 (of 242 total)