Viewing 5 posts - 151 through 155 (of 155 total)
vinaydiwakar (8/27/2009)
3) Scheduled a log backup daily, since mirror is there I don't need the log backup so I delete the backup file as soon as it's created.
Not knowing your...
August 27, 2009 at 8:25 pm
Hi Jose,
From comparing the two execution plans, it looks like the main culprit is the Nested Loops join instead of a hash join at the second last operation (i.e., at...
August 27, 2009 at 8:17 pm
No, the only columns you can include in the SELECT clause of a GROUP BY are aggregates, or those used in the GROUP BY. The reason for this is that...
August 26, 2009 at 1:26 am
If you're wanting to record the date/time that the record was created, you don't want to use the Timestamp datatype as is unrelated to datetimes.
Instead, add this field to the...
April 18, 2007 at 8:28 pm
The first thing that jumps to mind is that if your total row length is greater than 8K (eg if you have 5 VARCHAR(2000) fields = 10,000 bytes), you may...
April 15, 2007 at 11:37 pm
Viewing 5 posts - 151 through 155 (of 155 total)