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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy