Lavanyasri (10/8/2015)

---

Hi all,

i am pallning to apply sql 2008 r2 sp3 on cluster with mirror environment. please let me know how to do that .

environment is 2 node and 4...

terry999 (10/8/2015)

---

Thanks for replying Perry.

I have no idea how it is configured as Virtual server e.g. on the physical machine.

From user of the virtual machine it appears at 2 disks,...

all replies to this thread please

http://www.sqlservercentral.com/Forums/Topic1726452-3411-1.aspx

Then you'll need to refer to my Stairway to...

EasyBoy (10/8/2015)

---

We would like to change the servername.

i.e New ServerName is A (2014) and old ServerName is B (2005). Then we want to rename A (2014) to B.

Never mind. We...

are you saying with a restore you wont see enough recovery to cause any impact?

jackimo (10/8/2015)

---

We have a situation where we have a close to full database drive. Not urgent but getting close.

We run SQL Server on VMWare with an EMC San. ...

you'll need to drop the constraint and recreate it, if you don't specify any different the clustered index will be create on the PK columns.

Drop the constraint using

ALTER TABLE [schema]....

terry999 (10/8/2015)

---

Hi

We have a SQL Server running on a virtual platform.

I was wondering if the old recommendations w.r.t disks still make a difference, things like

1. Logs on one disk data...

so, you have 2 separate computers one with old version of windows and sql 2005, the other windows 2012 with sql server 2014, correct?

You want the sql server instance on...

thank you for your feedback, I'm hoping that users find the index column order data useful too

masking is not available in the sense that Oracle provides, as said already, just provide update scripts to obfuscate the tables

Duran (10/7/2015)

---

Hey there,

I hope somebody can point me in the right direction. I am trying to do the above using the following...

ALTER SCHEMA [dbo] TRANSFER [schemaame].[tablename];

...but getting the following error...

Msg...

Yes when creating the windows server...

Chitown (10/7/2015)

---

I have heard that high numbers of VLF's aren't good. It can impact performance and can delay recovery time, so I wanted to test that.

I created 2 DBs with...