Viewing 15 posts - 7,351 through 7,365 (of 7,608 total)
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
When read literally, today's question is simple and straightforward.
Quite true. The second part is clearly false, since "When [you are] dealing with table variables, ...", you cannot define indexes...
June 25, 2012 at 10:37 am
If that is the case, are there any advantages to using a table variable over a temp table? ...
Is there actually any advantage over using a session scoped temp table?
AFAIK,...
June 25, 2012 at 9:28 am
"A Table Variable can have primary keys and indexes defined." I don't see the word "you" in there. Can indexes be defined on a table variable? Well, they can exist,...
June 25, 2012 at 9:12 am
Computed columns are generally very efficient.
Also, they keep the column name the same for everyone -- CTEs get re-coded and so the column names can vary greatly from one piece...
June 22, 2012 at 2:27 pm
Viewing 15 posts - 7,351 through 7,365 (of 7,608 total)