Nice catch, Sean. I wouldn't...

Sean Lange (5/7/2015)

---

spaghettidba (5/7/2015)

---

T-SQL is a horrible tool for this job and using the CPU of the SQL Server box to send pings is not a wise choice, generally speaking....

Stone

Thief

Brent Ozar (5/7/2015)

---

Ed Wagner (5/7/2015)

---

While I guess I'd expect Microsoft to put more and more into Azure, it has a long way to go to catch up with the boxed...

Buffer

While I guess I'd expect Microsoft to put more and more into Azure, it has a long way to go to catch up with the boxed product. I just...

Using the @id variable to simulate your parameter, you can do something like this:

DECLARE @id NVarchar(15) = N'127.0.0.1'

DECLARE @strCmd Nvarchar(20) = N'ping ' + @id;

EXECUTE xp_cmdshell @strCmd;

Hopefully, this is a...

Another difference is when you create nonclustered indexes on the heap, each row can't inherit the bytes of the primary key. Instead, it inherits the bytes of the RID...

Schedules

Thanks, Steve. Nice question to get the brain cells going.

Thanks, Jeff, for you help on this one. I was off yesterday and nowhere near a computer.

Lynn, glad to hear it's working.

I think the whole approach is the right one. Writing stuff that works, checking itself along the way and doing the work that needs to be done, is the...

G ood question. It caused me to really think it through and caused a twist or two along the way. Thanks.

Nice question, but I guessed. I've heard good things about CMS, but never had the chance to really dig into them and play. Thanks.