peter.row (7/11/2014)

---

I know the article is this simple to highlight the issue but I assert in real life you would not do this.

If you are doing dynamic SQL then unless...

Excellent point. I should have included sp_whoisactive in the article. It is an awesome tool.

I've had days where killing the developer was discussed. Primarily when an Access query was left open over the weekend and blocked the batch cycle that ran at 2am...

Yes if you use KILL to end a transaction it will be rolled back and any changes made by that transaction will no longer exist. Unfortunately sometimes there is...

The KILL command does end the transaction being run under the specified SPID. It then has to roll back of course so there may be a delay depending on...

My top two "bad data" lessons both come under the heading of "my own damn fault"

May may years ago I was running some final tests to confirm a move to...

I'll take this one.

I'll take this one.

Excellent question. I particularly liked the format.

I had it narrowed down to 2 choices but couldn't remember the specific errors for each! Darn it. Good thing I...

WayneS (5/7/2013)

---

Kenneth.Fisher (5/6/2013)

---

Nice job introducing SQLCMD. I spent several hours this weekend trying to write up an intro to SQLCMD myself. You did a much better job than...

sneumersky (1/17/2014)

---

Charles Kincaid (1/17/2014)

---

I added the emphasis. Yes, understanding this execution order is why I have been able to write good performance...

+1

Great question!

Personally I like these. It always helps to know additional ways to do...

Not that I know of. Do you have the specific error?

Just a thought. If you haven't already done this you might try making a backup copy and...

If I understand what you are asking what you are looking for is DTEXEC.exec at the beginning of the command.

I did a blog on creating SSIS commands here[/url] that may...