Try sp_whoisactive. Be sure to look at all of it's parameters. INCREDIBLY powerful, and FREE!! Find it on SQLBlog.com, including a 30-day blog post series by creator...

Users - BAHHH!!! Who needs 'em?!? 😀

1) Search SSC.com for DelimitedSplit8K for a MUCH better split function. However, I predict that the splitting improvements will have essentially ZERO effect on the performance of this process....

Unfortunately for the SQL Saturday (and other conference precons) you have to be there. Some may be able to be downloaded if you pay, but not sure about that.

Hey,...

russ_hardie@hotmail.com (7/2/2014)

---

Thanks so much! The company am at now uses the 'catch all' you describe for a lot of reports. With your link I may be able to...

ducon (7/2/2014)

---

While I agree about the overall sentiment, I think that there should be an automatic flag to set threads to R/O from the system then. Say, if last activity...

GilaMonster (7/2/2014)

---

To be honest, most things I would leave at default unless I have a good...

My SQL Saturday Performance Tuning Precon? I am also building a new session entitled "SQL Server Defaults SUCK!!" 🙂

1) Monitor regularly for long-duration blocking and deadlocks. Common "performance" problems that are often easily fixed

2) One of my best tools is aggregate Profiler analysis. The free Qure...

@murali (7/1/2014)

---

Thanks to All..!

Sure, I will go through the blogs/scripts.

But I am curious to know SQL Server internals how SQL server pick the tables, will it choose the tables...

create index ix_Split_1 on #Split_1 (NewParameter)

Good call on the joining to a split-built derived table and how putting that into a temp table could make things faster. However, I...

1) That would lead to a hijacking of this thread.

2) I want to find out privately what the issues were...

I would love to...

SQLRNNR (6/30/2014)

---

Be careful with the SPs in 2012. Both SP1 and SP2 have a bug that can cause data loss when performing index rebuilds online.

There are CUs (CU9 for...

Did you check for blocking?? People forget that concurrent activity can stop SELECTs in their tracks for extended periods sometimes.