Lynn Pettis (7/3/2012)

---

Doing it something like this:

alter table MyTable

Add Constraint [MyPrimaryKey] Primary Key (MyColumn)

WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON);

Be sure to verify the complete syntax in...

If the logical key nonclus index needs...

Also, do a

DBCC UPDATEUSAGE

on the table. Heaps seem to report ridiculously incorrect page totals too often for comfort. I've had SQL telling me that a single...

CELKO (6/27/2012)

---

NO! That is...

Eugene Elutin (6/27/2012)

---

Not for nested transactions, check this one:

begin transaction outerOne

update Table1 set Col1 = 'booo' where id =1 ...

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.

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...

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...

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. ...

Perry Whittle (6/26/2012)

---

Scott i don't disagree with you, we know that multiple arrays are ideal but all we're saying is in this case you have to go for something a...

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...

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...

You can also use a structure like this:

WHERE 1 = CASE

WHEN @var = A AND [column] IN (A, B) THEN 1

WHEN [column]...

OK, but it's not the odds against losing it, it's...

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...