Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backups
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:
> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for backups
> and t-log backups.
> Thanks

Logic for adding dates

If I use dateadd(dd,n,@.fromdate), it gives me the result including the weekends, is there a way to find the target date without including weekends. Please help.There isn't a way with the dateadd function. You'll need to create a date table that excludes weekends and holidays. You can the do a count from the table BETWEEN @.startdate and @.enddate.|||What logic do you want? I can think of two possibilities:

A) If date falls on a weekend, use following Monday instead.

and 2) "n" represents the number of non-weekend days to increment @.fromdate.|||Yes, if the date falls on a weekend then we would use the following Monday. I've got the field updating OK on the plus 3 days but now I have to account for the weekends and holidays.|||Dude! Are you the original poster? This thread is three years old!|||Nope sorry wrong thread.|||Wrong thread.