Steve Jones - SSC Editor (7/31/2013)

---

SQLRNNR (7/31/2013)

---

Steve Jones - SSC Editor (7/31/2013)

---

So I get this is probably in jest and partially true, but it's insulting. ...

That being said, the icons...

PhilipC (7/31/2013)

---

Has anyone noticed how vendor databases in general are getting worse and worse? It seems we're getting to an age where regardless of quality, it's just get the product...

Steve Jones - SSC Editor (7/31/2013)

---

So I get this is probably in jest and partially true, but it's insulting. ...

That being said, the icons shouldn't have been rolled out without...

you petitioning for twinkies or ding dongs?

Where do we send the...

the previous doc mentioned should help you get the databases moved.

me

You can try the query in this article

http://www.sqlservercentral.com/articles/sp_who2/70222/

You can also try sp_whoisactive (link in the discussion on that article.

Is your query running a loop, cursor or does it have multiple batches within it?

one method is to use dbcc inputbuffer

The usual way would be to monitor specific queries and evaluate the execution plans of those queries. You run the query, tune the indexes as appropriate (keeping in mind...

You could teach them how to do it via SQLCMD or PoSH.

As far as a GUI tool, I don't recommend anything other than SSMS for User Administration.

If you have a...

Spook

I think the first step is to instill a sense of ownership / pride in the developer in the product they develop. If you own it, are you happy...

The tool to use would be SSMS

Here is an alternative article you can follow if you would like a different way of doing it with SSIS

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/87652/