If you do a search in the scripts section here on SSC I'm pretty sure there are one or two T-SQL scripts that can do some compares. But they're seriously...

dbassassin (1/13/2014)

---

Grant,

I read at brentozar.com:

http://www.brentozar.com/blitz/jobs-owned-by-user-accounts/

http://www.brentozar.com/blitz/database-owners/

So would you recommend striving towards not using SA (possibly even renaming/disabling it), and creating new accounts that are least privilege for specific purposes?

I've always setup...

mxy (1/13/2014)

---

thanks again. I dont have any performance issues right now to share execution plan or ddl code. when we discuss last we in team meet we have discussed all...

A linked server isn't direct. It's a hop away from the server. Direct would be to open a connection to the second server from the app code. But that's a...

But the deadlocking must be occurring in and around that table. You need to concentrate on the queries that are accessing that table. It has to be the one associated...

I'm confused. Please let...

Not sure why you're getting the error without seeing more about how the code, your servers, the connections between them are all configured. But, you are using distributed transactions because...

Sean Lange (1/13/2014)

---

There is a LOT of low hanging fruit here for performance improvements. I would say that 36 seconds is outside of the acceptable range for a query running...

If you're seeing one set of behavior from SSMS and a different one from SSRS, the possibility could be bad parameter sniffing, but, the way to address that issue is...

Deadlocks are a performance issue. It's all about the ability of transactions to clear prior to arriving at a deadlock situation. From the sounds of things, you've probably been borderline...

Again, I'm with Gail. I couldn't even guess. It could be almost anything from bad parameter sniffing to problematic code to missing/incorrect indexes to one query moving a lot more...

I've been using a 3rd party tool to do that for the last 15 years. Actually, I liked their tooling so much, I went to work for that company about...

Yep. That's my understanding too. If you need to have a large number of developers using Microsoft tooling, I'd suggest contacting Microsoft directly and negotiate an MSDN license for your...

Like Gail says, T-SQL is T-SQL. Dynamic T-SQL will prevent some levels of code reuse which can lead to increased CPU use as more and more queries have to go...

If it's asking for a serial number, you've gone past the 14 day free trial. You can contact sales and request an extension. Otherwise, you'll need to purchase the software.