Viewing 15 posts - 1 through 15 (of 21 total)
Hi all
I think eric.fung and bakwas28 are correct -
As Eric said:
I just thought that if I can successfully maintain every log backup, say from Mon day to Friday, then...
August 21, 2008 at 4:03 am
Don't forget, if you run up against the limitations of the built-in types, you have the option of creating your own user-defined types.
Unfortunately, it does require CLR integration to be...
October 26, 2007 at 1:57 am
Hi
Fantastic article and a good detailed look at an important area of functionality. Thanks for your time!
A couple of comments:
- Third paragraph from the end, it says "CURRENT_TIMESTAMP function is...
October 24, 2007 at 3:00 am
As noeld says, the key is in minimising the size of your transaction (and therefore the amount of data which must be logged to your transaction log before the data...
December 5, 2003 at 2:50 am
Well, with the way most RAID works with more than two disks, the data is split up into "stripes" across all disks in the array, so it doesn't really improve...
December 5, 2003 at 2:42 am
Well, it just so happens I'm building a similar tracing mechanism myself at the moment!
As an experiment, I tried both SET @Source = OBJECT_NAME(@@PROCID) and SET @Source = 'String Literal'...
December 3, 2003 at 3:50 am
I agree with most of the voters at this time... the non-clustered index option is not only a viable solution, but is in fact probably preferable to changing the existing...
November 21, 2003 at 4:04 am
Interesting QOD - knew the answer from the last time round.
I can only find the reference to multiple ports functionality in the SP3 version of SQL Books Online - does...
October 8, 2003 at 2:33 am
Well, in the absence of any other information, I assumed that the question was about row counts, and that the SQL UPDATE statement itself would not produce an error.
The red-herring...
September 29, 2003 at 3:44 am
I think this question highlights MS's advice that you buy identical machines for a cluster configuration.
Not only is there less chance of configuration problems, but it also means you...
September 22, 2003 at 10:42 am
This comment isn't directly related to the question, but it may also be worth noting that if you set a database in single user mode using ROLLBACK and you are...
September 1, 2003 at 2:35 am
quote:
I was surprised to read you can't use controller cache on clusters.
This limitation only applies...
August 7, 2003 at 4:57 am
quote:
When you use RAID5, isn't some percentage of the total space allocated to the checksum or whatever it's called?
August 6, 2003 at 9:40 am
Hi
So things have progressed a bit, and one of ideas we have is a FAStT600 with 8 x 146GB 10,000RPM drives.
Now, considering we need as a minimum:
(i) At least two...
August 6, 2003 at 4:29 am
Thanks for the reply, Andy. The enclosure I'm looking at holds 14 drives, so 73GB drives will give us around 800GB usable capacity in RAID-5, assuming a single physical array...
August 5, 2003 at 4:10 am
Viewing 15 posts - 1 through 15 (of 21 total)