The vendor will have a best practice guide for SQL Server on their SAN.

I suspect it may suggest otherwise.

I'd most certainly keep SQL Server and "Other" storage totally...

Eric M Russell (7/15/2014)

---

At least for as long as I can recall, and probably dating back to Sybase, SQL Server has given the developer some flexibility over isolation level. Starting...

SQL2219 (7/15/2014)

---

Like I've always said: a good developer recognizes that he can't be an expert in everything. I once had someone ask me if I was a SQL expert,...

Phil Factor (7/15/2014)

---

@patrickmcginnis59

Yes, it is certainly possible to have a NoSQL database that handles ACID properly. It just surprises me that some don't. As I understand the Bitcoin exploit,...

msandico 57892 (7/15/2014)

---

andrew gothard (7/15/2014)

---

do you have a team responsibe for your storage, or is it you?

If you have, give them the date and time of the first messages and...

do you have a team responsibe for your storage, or is it you?

If you have, give them the date and time of the first messages and ask htem to check...

I/O related. If you've had two, then this means there is almost certainly s significant issue with some area of the I/O stack. Have you had any 823,...

The moral of the story being, if your database vendor doesn't use it for their accounts, don't run your 'bank' on it.

While there are differences between visors, the basic concepts are the same...

I've got a home rolled one that's still a...

StephenNL (7/8/2014)

---

Here some data of our vm:

NUMBER OF VM: 1

RAM: 16 GB (static)

CORES: 4

HD: IDE, 150 GB.

Filesize (mdf): 5.92 GB

Filesize (log): 3.93 GB

The capacity of the cpu (VM) during the...

Running te collection scripts and storing to a central monitoring server using powershell scripts is a pretty powerful option as well, and one I personally quite like.

SSIS is a good...

How many cores does your VM have - what's their use %? If it's low (you're over provisioned) you need to drop some cores, overprovisioning VCPUs on a SQL...

Koen Verbeeck (6/25/2014)

---

Stefan Krzywicki (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What...

"I know - why not just put the entire address in one column, what could possibly go wrong there ... "

The number of times I've seen that bit of idiocy...