Nice article.

Here's a similar one, but it compresses both tables and indexes:

www.i-programmer.info/programming/database/5535-a-generic-sql-server-compression-utility.html

thanks

Ian

Hi, for books, see this discussion : http://www.sqlservercentral.com/Forums/Topic1724468-3728-1.aspx

thanks

Ian

Hi Gaurav/Daniel,

sorry to interrupt, but I’ve also gone through this process, so hopefully can add something of value.

I’ve been working with Hadoop for the last year or so. During this...

Hi,

Much Hadoop processing (MapReduce or In-memory) needs low-level programming knowledge. Typically batch MapReduce uses Java, but scripting languages like Pig can also be used. With in-memory processing, Spark is...

Hi Daniel,

yes you are right of course. I was talking in terms of generalities...

The Hadoop world in general is moving towards in-memory processing instead of MapReduce batch processing due to...

RE PolyBase... Have a look at the job websites, book sites etc. Hadoop and its components are largely a unix/linux thing. I suspect the market for PolyBase, like HDInsight, is...

Hi, thanks for this very useful overview.

You might want to know that Impala is a popular tool for querying data in Hive quickly (it uses in-memory processing instead of...

Hi

Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or 33...

Nice article!

You might also want to look at "What SQL Statements Are Currently Executing?"

http://www.sqlservercentral.com/articles/DMV/64425/

Thanks

Ian

Hi,

very nice article.

There's a chapter on the same topic (called the Self-healing database) in the book SQL Server DMVs in Action http://www.amazon.com/SQL-Server-DMVs-Action-Management/dp/1935182730/.

It contains SQL code for automatically: recompiling slow routines,...

Hi Megistral,

I understand your concern, but sometimes, time is of the essence…

Remember you will be running with a transaction isolation level of READ UNCOMMITTED , and you’ll only be SELECTing...

Hi Phil,

Just so readers understand this clearly, the DMVs do not access private data (e.g. customer details), instead they access metadata (e.g. what queries take the longest time to run)....

Hi,

there's probably nothing wrong with running (most) DMV scripts on production.

Remember the information largely already exists anyway, you are just harvesting it... Also to set the transaction isolation level...

Hi,

Very nice article!

Readers can discover a lot more about improving SQL performance via DMVs in this recently published book "SQL Server DMVs in Action" www.manning.com/stirk. It contains more than 100...

Hi everyone

Thanks for your replies.

I feel like a sinner today. I did wonder several times if I should publish this article, but decided it hopefully has more advantages than disadvantages....