Viewing 15 posts - 7,351 through 7,365 (of 7,602 total)
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
if I included those computed columns and accessed the table via a SELECT * query elsewhere, would it also return those columns?
Yes. In that case, SQL would consider that...
June 22, 2012 at 12:29 pm
You could use a DDL CREATE_TABLE trigger to:
1) rollback the CREATE TABLE if the schema is not dbo (this should greatly help in forcing others to explicitly change their code...
June 22, 2012 at 9:27 am
Unfortunately, I can't add anymore columns to the existing table without causing it to bloat up more.
Keep in mind that computed columns are NOT physically stored in the table,...
June 22, 2012 at 8:08 am
Since there's only three dimensions being tested, I wonder if it's easier to just add computed columns to the base table and do all the calcs inline in one query,...
June 21, 2012 at 2:13 pm
A sysadmin can't be denied anything in SQL Server, so something else is going on here.
Is this a SQL login or a Windows login?
If W, is it a group or...
June 21, 2012 at 1:39 pm
Viewing 15 posts - 7,351 through 7,365 (of 7,602 total)