Ed Wagner (3/28/2014)

---

Oh boy - I should have kept my mouth shut. Please, no pictures...

JoshDBGuy (3/28/2014)

---

New Born DBA (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you need to...

Jeff Moden (3/28/2014)

---

SQLRNNR (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of...

Sure sounds like you're either not backing up transaction logs or not backing them up often enough. Read more about it here[/url].

It's also possible that you have a broken replication...

mpdillon (3/28/2014)

---

Grant,

I did not know that so thanks for the advice. In this instance I have a Server dedicated to testing. I am the only one using it. I turn...

In general, I suggest putting the clustered index on the most commonly used path to access the data. This is because the data is stored on the clustered index.

yuvipoy (3/28/2014)

---

1) Ok, Say i am droppping foreign keys and start deleting the records,what will happen in the middle of delete , if the server is broken, how to reenable...

Yeah, it's pretty likely that FKs are checking each constraint. You can look at the execution plan to confirm this, but I'm sure it's accurate. If you are doing very...

Another thought, are there assumptions built into the code that the next value will always be one greater, because starting in SQL Server 2012, there can be large gaps in...

It's the MOVE option you need. The RESTORE statement will attempt to restore the files defined in the backup. So, in order to restore to a new database, you also...

The issue of Data Definition Language statements. CREATE TABLE, ALTER PROCEDURE, etc. Here's the entry in Books Online with a lot more details.

What exactly are you looking for specifically?

Sorry? What?

Do you mean set up an extended event session to capture sql batches and rpc calls? That's a good idea. I'm not sure...

It really is down to a unique setting for each alert, sometimes a unique setting for each server for each alert. There's no single answer to any of these. As...

You can use ORDER BY along with TOP 1 to get the row that has the highest value.

ShowPlan and StmtComplete are extremely resource intensive events to capture. Be very cautious doing this on a production system.