I thought of the same. However, it appears there are close to 4k procs and I am looking at transferring around 2.5k. I felt scripting out will be taking long...

OK Thanks. So a disk failure in this case should perform an automatic failover as the instances are different and so are the SANs. correct?

mandated by upper management to reduce downtime.

Steve Jones - SSC Editor (5/24/2016)

---

It's complex, and I think step #3 can perhaps be more difficult that you imagine. How are you sure the data is up to date?...

Eirikur Eiriksson (5/14/2015)

---

Sapen (5/14/2015)

---

Hello,

I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly couchbase)....

Because we are on standard edition and not enterprise

WHat should be modified here if starttime is 9:00AM and endtime is 6:00PM and lunch is 12:00PM to 1:00PM

I will be passing the starttime and endtime as ('2015-01-01 10:20:01.001','2015-01-01 17:29:21.001')

Where shd i make changes to the script if work hours are 9:00AM to 6:00PM and Lunch hours are 12:00PM to 1:00PM?

Thanks

Alan.B (3/23/2015)

---

Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these indexes...

roblew 15918 (3/23/2015)

---

Just hit a issue where we had a 40gb backup file for a database with an mdf of less than 2gb and tran log less than half a...

Simply shrink the data file and it will cause fragmentation.

You can insert,update and delete tons of data into this table and you will notice fragmentation. Script from Robert works...

shahgols (3/20/2015)

---

Hi everyone, I have been looking online for permissions that only sysadmin has, but couldn't come up with a list. What are the permissions that are only sysadmin?...

Absolutely