Viewing 15 posts - 7,336 through 7,350 (of 7,597 total)
Code looks OK to me.
Regarding date formatting, I'd suggest using 'YYYYMMDD', which is foolproof on SQL Server, rather than 'YYYY-MM-DD', which can fail depending on specific settings in SQL Server.
June 27, 2012 at 3:46 pm
You could have tempdb data files on both RAID1s for performance reasons, simulating something of a faux RAID 10, recoverability obviously not being a factor for tempdb.
Depending on...
June 27, 2012 at 10:34 am
The contention (I think) is where some folks latched onto something you said that implied you knew how to recover from a lost array in a 2xRAID1 setup with no...
June 26, 2012 at 4:58 pm
I think this series of articles is pretty good, and yielded some interesting results about RAID:
http://www.kendalvandyke.com/2009/02/disk-performance-hands-on-part-6-raid.html
That's not to say this article is the last word on RAID or anything. ...
June 26, 2012 at 4:48 pm
Perry Whittle (6/26/2012)
June 26, 2012 at 4:26 pm
As I understand it having database files stored across two arrays (data on one array, logs on the other) gives us a better chance of recovering to the point immediately...
June 26, 2012 at 4:07 pm
You lose the db as it exists if a RAID1 fails, but if you place the files properly on the two RAID1s, the db can be fully recovered, which would...
June 26, 2012 at 2:10 pm
You can also use a structure like this:
WHERE 1 = CASE
WHEN @var = A AND [column] IN (A, B) THEN 1
WHEN [column]...
June 26, 2012 at 1:19 pm
You're more likely to lose a complete RAID1 mirror, than you are 3 drives out of a 4 disk RAID10 array
OK, but it's not the odds against losing it, it's...
June 26, 2012 at 9:29 am
My concern with one big RAID10 is again "survivability". If you do somehow lose the (4-drive) RAID 10 here, all the dbs are also lost.
With two RAID1s, you can...
June 26, 2012 at 8:42 am
With RAID1 you lose spindle aggregation - such that it is with just 4 drives in the RAID10.
Even with my specified condition of:
database filegroups with two files, one on each...
June 25, 2012 at 4:17 pm
agree on the whole but you would almost certainly notice some performance degradation whilst the RAID1 or 5 array is being rebuilt.
True, but RAID1 with a good controller should not...
June 25, 2012 at 3:40 pm
The author clearly meant #2. Most of us were reading #1. The wording is definitely ambiguous.
I suppose it's somewhat ambiguous.
But #2 is so illogical and extreme given everything...
June 25, 2012 at 3:21 pm
Being a DBA, I'm as concerned with recoverability/"livability" as with speed.
Having all your data and log files on one RAID5 provides no inherent recovery capability. Are the SQL trans...
June 25, 2012 at 2:27 pm
2. A Table Variable can have primary keys and indexes defined
Baloney.
"Defined" is inherently an action, not a state.
You cannot "define an index" on a table variable in SQL Server.
If the...
June 25, 2012 at 2:05 pm
Viewing 15 posts - 7,336 through 7,350 (of 7,597 total)