I agree with Jason. This sounds like a data quality problem, not a MERGE problem. The error is quite explicit - you can't (shouldn't) have duplicate keys. ...

Sagar-636902 (3/18/2015)

---

Thanks, appreciate for that response. that did not give any return.. question is that 'DB STARTUP' command get blocked every now and then for second or two. is...

rwitt 95744 (3/18/2015)

---

Greetings,

I have been using actual execution plans & Database Engine Tuning Advisor to analyze performance. My questions pertain to interpreting exactly what Database Engine Tuning Advisor is telling...

Take a look at this thread to see if anything is helpful, especially ALZDBA's scripts.

http://www.sqlservercentral.com/Forums/Topic1331473-391-1.aspx

Don't contact him first. Try to resolve the issue yourself first. Most likely it is something...

It will expand your mind and your TSQL tool kit - both of which are desirable!! 😎

Sagar-636902 (3/18/2015)

---

Hi, Please help me here to figure out the fix.. i have very large database that is setup in availability group. One of the database has log is filling...

Do a web search gaps and islands itzik ben gan. Or dwain camps instead of itzik. This is a very classic problem with MANY solutions, including some very...

Ola Hallengren is very responsive to emails if you find an error message in your text output file that could be a bug or opportunity for improvement in his maintenance...

DBCC memorystatus may be cumbersome, but it breaks down the memory buckets/usage just like you need to see it for this issue I think.

Check out Glenn Berry's SQL Server Diagnostics...

shahgols (3/16/2015)

---

Hi all,

I have a virtual server dedicated to a single installation of SQL Server Enterprise edition. The box has 224GB of RAM. 190GB was assigned to...

"planning to do a scale": what does that mean, exactly??

Done right, SQL Server can be successfully virtualized to run almost any workload. Done WRONG, and you can't buy...

Another great option is Ola.Hallengren.com. His AWESOME, FREE, DOCUMENTED stuff offers up the full range of maintenance needs too!!

Please don't respond to 4-year old threads Steve. Thanks!

I have been a "real-world" SQL Server consultant for almost 20 years now. I have managed SQL servers with well over 7000 databases on per server. You CAN...