There's no easy way to do this, like Kevin says. One thing you can try is to use either views or in-line functions to expose a common object name to...

Red Gate SQL Compare works quite well with Windows Azure SQL Database.

Disclosure, I work for Red Gate.

SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the database. You can't both SELECT a row...

Yeah, of course. Both processes are going to use CPU and memory and I/O. Therefore there's a very distinct possibility that the two processes may be in contention on those...

Extended events is not easier than trace, but it's pretty easy and certainly has less impact on the server. Books Online will get you going.

That's an excellent point. Sounds like you're doing fine. If you hit issues, you know where to go for help.

Lookup the data types of the underlying columns and then manually set them. That's the only way.

Sean Lange (6/5/2014)

---

I am just going to leave this here...

http://www.sqlusa.com/bestpractices/%5B/url%5D

Don't worry there is soap for your eyes. Then if you read some of the content you may want to find...

sqldriver (6/5/2014)

---

So then what are plausible alternatives? What can I present as a change to say "you no longer have to risk incorrect results by using NOLOCK because A is...

patrickmcginnis59 10839 (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where...

Jason Strate has a great example that shows the effects of NOLOCK.

But, one little thing, just on the side, why write code where you put NOLOCK everywhere. If you're really...

While you can use trace, extended events might be a better way to go. The filtering on trace events occurs after the event is captures while the filtering on extended...

SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was...

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I), but I...

Those times are in milliseconds.

Usually, the way I measure performance for a query is to SET STATISTICS IO ON and SET STATISTICS TIME ON for the query window I'm operating...