GilaMonster (3/16/2015)

---

Igor Micev (3/16/2015)

---

You can...

You can use the DROP_EXISTING...

I knew it's possible but didn't know that it could be with the -x option in the startup options.

Thanks

I knew it's possible but didn't know that it could be with the -x option in the startup options.

Thanks

A big and interesting system. You have to specialize on it using the maximum of the Enterprise features of SQL Server. For e.g.:

- Partitioning is something that you must include....

This link is one very useful - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/.

Resolving deadlocks is usually a long-duration task that requires from you to overview more aspects.

What is the number of records that are you deleting in some of the tables? it...

GilaMonster (3/10/2015)

---

The SQL parser does not and can not execute code. It's a parser. It encounters the same temp table being created twice, hence throws an error.

Solution: Create the temp...

Nice question. High quantity of information with regards to the security by using certs. 😉

Eric M Russell (2/17/2015)

---

Igor Micev (2/16/2015)

---

This is a good notice. System databases' process should be avoided.

@author: What about...

Interesting. I like questions that make me think up a bit more.

This is a good notice. System databases' process should be avoided.

@author: What about if you want to kill...

It's most likely that a security issue is in question, but can you check that the service accounts have the same privileges. Also, you should give some more explanation of...

Perry Whittle (2/13/2015)

---

Hmm, I thought so. This is not exactly a bug, although BOL should explain a little better what happens when you restore a DMK :angry:

When you restore the...

Interesting question 🙂