YSLGuru (7/27/2012)

---

Steve Jones - SSC Editor (7/26/2012)

---

SpringTownDBA (7/26/2012)

---

Ok, I understand what you're describing.

If the VM host is ONLY going to host 1 VM EVER, then what is the value...

YSLGuru (7/26/2012)

---

...

"What does it mean that "only the OS would be on the VM and the database files would be on local drives"?

Its my understanding that the Windows...

allmhuran (7/25/2012)

---

In the microsoft documentation for restrictions regarding alwayson availability groups ( http://msdn.microsoft.com/en-us/library/ff878487.aspx ), the following appears:

"If the file path (including the drive letter) of a secondary database differs from...

YSLGuru (7/25/2012)

---

Thanks Lynn and Steve. I had already asked for the guys to switch the RAID 5 drives over to RAID 10 and forgot to note that in my...

joseph.devereaux (7/25/2012)

---

Looking for "standards" or opions : Which is better and why?

I have always a file creation size, file growth amount and max file size. Usually this is 1st...

detach the database files before moving the luns.

You are having performance issues on the SQL server. This is the root cause of your problem.

As a side effect, your application is opening additional connections to service requests...

There ia a problem with what you're trying to accomplish.

Basically, you can't do it. Sql doesn't allow dynamic naming of columns in views.

You have to do something like...

This is a different way to chunk your deletes. It populates a temp table of keys, then picks the first N keys, and deletes rows associated with them, then...

yes, but on a smaller scale (table < 1 gb).

good luck!

easy ones first:

non-default configuration for "locks"?

SELECT * FROM sys.configurations AS c WHERE name = 'locks'

another spid using tons of locks?

SELECT request_session_id, COUNT(*) FROM sys.dm_tran_locks AS dtl GROUP BY...

Take the total size of the clustered and non-clustered indexes (include non-leaf pages) and add 30%. I pulled that figure out of thin air, but it should be sufficient

though,...

Tom Van Harpen (6/27/2012)

---

The title is a bit misleading, it is applying the view where clause but after it does a compute scalar which is causing the error.

We have a...

hard to say without the execution plan.

oh, and to answer your second question, a primary key exists to enforce uniqueness, nothing else.