Brandie Tarvin (9/26/2012)

---

Steve Jones - SSC Editor (9/25/2012)

---

Nepal in Dec. I'd like to go to that one, not sure it's doable, mostly because of time. Takes 2 days to get...

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Should be in all editions.

You don't have to use Service Broker, but you want transactions as tight as possible. If you really want the queue on another machine, use a...

The trigger is part of the transaction. The AFTER won't release the locks for you.

You would be better served by using a real queue here with Service Broker. Insert the...

DAX is used in the SSAS world of Powerpivot

http://msdn.microsoft.com/en-us/library/ff487170%28v=sql.105%29.aspx

Nepal in Dec. I'd like to go to that one, not sure it's doable, mostly because of time. Takes 2 days to get there.

#169 in Denver was great this past weekend. I might be done with SQL Sat for 2012. DC is tempting and I'll try to decide soon, but timing doesn't work...

I hate wide receivers.

Jeff Moden (9/23/2012)

---

By the same token, there are also many myths that need...

If you central server is down, where is the data on backups? If your package has a bug, or can't connect to an instance, what happens to the data?

GilaMonster (9/21/2012)

---

Stefan Krzywicki (9/21/2012)

---

Wow, I frequently disagree...

First, do your best.

Second, you'll make mistakes and your solution won't be perfect. Get over that. Work the best you can and fix things as you find issues, but don't...

First, I'd make sure you are copying those full backups around to other places. If you lose one of them, you don't want to be going back a month or...

I like your second idea, personally. If you need all phones, use a UNION.

One side note: please allow people to change/alter the phone types. I hate on the iPhone that...

Sean has a good solution, but I'm wondering, do you need to search on end date, and if that's not there, then search on the number?

Objects in tempdb should clear when the connections drop or they are dropped by the connection that created them. There are some objects created by the system to satisfy queries,...