thats some really great article. simple presentation and nice explanation of the code involved. would it be possible to share the code for disk space and CPU usage also? 😀

nice article, with lots of commands and examples. I only think the article name should indicate that it is refering to the database Files, not the actual database name (or...

It's interesting to note that the index usage pattern can change drastically in a case-by-case basis.

But I was also impressed with the usage of CTE's in this article. Great way...

I was gonna talk about the logged/non-logged issue also, but that topic has been covered already.

so I came here to thank about the usage tips for those undocumented procs. it's...

it can work when we have control over the application's database code. but for languages that depend on ORM and a lot of abstraction this could be nightmare.

from my experience...

Rudy Panigas (12/31/2014)

Closing your blog with my article is nice and thank you. When I link to articles from my blog I mention the original author's name in blog to...

GilaMonster (12/31/2014)Nothing wrong with cross-database queries. Performance-wise they're the same as queries within a database. There may be some security amusement. There are good, valid reasons to split an app...

I decided to close my 2014 blogging year by linking your article, Rudy.

Please take a look at it: https://thelonelydba.wordpress.com/2014/12/30/last-post-of-the-year-sql-server-2014-checklist-for-performance/

Also instead of discussing any general tip, I would like...

thanks for sharing!

I am tweeting and blogging your post. Sometimes a simple solution that can be customized with the least possible effort is the best way to get things done.

I...

Meow Now (9/19/2014)

---

With our CR process it takes me a week to get a procedure change pushed. A full version upgrade on a production DB would take about 1 year...

This is good for intranet websites, where external monitoring tools aren't allowed. Its nice to know SQL Server can do it!

I would suggest adding some logic/tables to read the URLs...

JimAtWork (2/3/2014)

---

I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not allow the...

nice article!

note: the first code sample is outside of the "brackets".

you are correct, @opc.three. I just wanted to point out that even the unexpected should be expected at some point in time, given a large enough installed base.

I had...

until today, all my "online" index rebuilds worked as expected. but just today I got...