TheSQLGuru (3/27/2014)

---

This is a concurrency issue, therefore I am 99.984% certain it is a CODE issue. Something somewhere is not properly handling locking and concurrency. As for why...

hboswell (3/27/2014)

---

This seems to be one area where the way I would have done this in Oracle just doesn't mesh with the SQL Server does things. I'm working on...

Sean Lange (3/27/2014)

---

sql-lover (3/27/2014)

---

Is someone else experiencing this problem, SQL2012, of course:

Violation of PRIMARY KEY constraint 'PK_MyTable'. Cannot insert duplicate key in object 'dbo.MyTable'. The duplicate key value is (1842649).

The...

cesarscorp2 (3/26/2014)

---

Good morning everybody! I am working with Mirroring an enviroment (Windows Server 2012 DataCenter) - 64 Bits and my SQL is SQL Server 2012 Enterprise. I do the configuration...

Indianrock (3/26/2014)

---

Our company has made the decision to gradually leave sql server in favor of DB2. We have a wide variety of applications ( many acquisitions ) running on...

You can try this one as well ... wrote by Paul Randal, I think ...

--virtual file latency

ReadLatency = CASE WHEN num_of_reads =...

Perry Whittle (1/22/2014)

---

Thats not correct, see my post above.

SFW HA has VCS...

adonetok (1/17/2014)

---

Company is doing server and application update.

I need to copy about 100 tables from server A to server B.

Since the project is under test mode and I need to...

ramana3327 (1/18/2014)

---

Hi,

Please let me know the main difference b/n Microsoft Clustering & Veritas Clustering.

What is the use of Domain controller in clustering? I mean is it mandatory to create domain...

This is not a DMV I wrote (can't remember where I found it, honestly) but it is the 1st thing I ran to find out what query is slowing down...

Usually, if you run the executable with the "/?" switch, it will display your choices.

On old versions of SQL, it was something like this:

C:\install\SQLServer200xSPx-.exe /allinstances /quiet

You can use a network...

Oracle_91 (9/30/2013)

---

Hi sql-lover,

Thanks for the query. However, this script would show only the buffer distribution. ITs doesn't include the memory allocations done outside buffer pool(i.e. memToleave or non-buffer or memory...

If this is a one time deal, you can use Management Studio and...

CheckDB does a CheckAlloc on the database, a CheckTable on each table and view, a checkcatalog. So I think there is a chance that checkTable won't catch problems that a...

robrseidel (9/27/2013)

---

Can dbWarden be installed on a nonproduction SQL Server and be used to monitor a production server? I installed dbWarden in our test environment and really like what...