Thanks Lynn!

Please check out the bottom of Jonathan Kehayias's blog page below:

http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

To know whether your value is good or bad, you have to know what "normal" is. That means...

You might be able to use the most_recent_sql_handle value from the dm_exec_connections DMV to get what you are after. It provides the SQL_HANDLE associated with the last request executed against...

+1

I configure a background server side trace on all...

I would recommend that you review Glenn Berry's diagnostic queries. He has different scripts for each of the relevant versions of SQL Server.

http://sqlserverperformance.wordpress.com/tag/dmv-queries/

Likely, the two most relevant...

SQLSteve (10/10/2013)

---

Appreciate your feedback guys and Gail I have also had situations where processes have come to a standstill, I have updated stats and it has helped it move forward.

Update...

I agree with Gail that the noticable performance improvement is more likely attributable to the updated statistics that occur with an index rebuild. That is another reason I like Andrew...

SQLSteve (10/10/2013)

---

I am going to incorporate into my reindexing script that any index under a certain size should be ignored.

Whats the rule of thumb for this? There must be a...

Totally agree. I...

This site is fantastic as a starting point. I would also highly recommend SQLSkills.com, particularly their blogs.

Read Koen's blog in its entirety and that will answer your questions. SSIS needs to be installed (the binaries) in order to run SSIS packages. The service that gets installed...

Great blog, thanks for sharing the link!

SSIS is a windows based service that gets installed if you select it as a component during the initial SQL Server installation. It is different than the BIDS GUI that...

I believe the manual effort of actually writing something down facilitates the learning process, at least for me it does. My comprehension of the material is better that way.

For me, it really depends on the purpose of the book. For "reading" books, I'm fine with eBooks on the laptop or the tablet. For "studying" material, it's still...