Alexander Suprun (3/23/2016)

---

Extracting the whole cache (which is gigabytes of data) + missing index DMV, saving them on another server and running parse for 40 minutes doesn't sound like a...

Hugo Kornelis (3/23/2016)

---

In almost 20 years of working with SQL Server, I have only once used an index hint in a production query, and that was after I found that...

I still don't understand the question. A nonclustered index is sorted. It has a key value. It gets sorted into a b+tree by that key value. The keys are ordered...

The descriptions for those are here. For the most part, most people don't bother with putting backups into a set that way. Instead, most of the time, people will initialize...

To see recent queries against a table, you can search sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text. It will have the queries that are currently in cache. That should cover most of...

Happy to help out. I'm rewriting the execution plans book. It should be done soon I hope.

Right. Not a backup. That wouldn't work. BCP a SELECT statement against the cache using the DMVs.

Nothing special. Treat the cache like a table. Run a query to export through BCP. Import that to another database as a table. Done. No special tricks, not moving memory...

Your best bet would be to offload the XQuery part of the work. Instead of trying to run the XPath stuff, which will do what you want, on your production...

You can do a trigger, but that comes with the possibility of considerable overhead depending on how it's done. You'll also have to sweat the log on the secondary database...

There are a lot of complexities with the cloud providers, but, yeah, they have a model that lets you basically rent storage and cpu space. You provide all licensing from...

BL0B_EATER (3/23/2016)

---

I might get slapped by asking this but what does it take to get an MVP award? ( just curious). To the people that hold one is it your...

It actually kind of is impossible. The missing indexes are, at best, suggestions. You can't simply blindly apply them. Further, if you look through them, there's a lot of duplication...

Mad-Dog (3/22/2016)

---

ok I'll try to capture the plans while i have this problem.

i update all the stats every night and rebuild the indexes once a week.

can i query the...

Sachin Nandanwar (3/22/2016)

---

Yes...