This has been a VERY hot topic for the SQL community. Thanks for posting this!

Steve Jones - SSC Editor (1/24/2011)

---

Kevin, very true. I think this one is mostly a 100 level, sometimes going to a 200 level of stuff. It probably needs to be...

Steve, I don't think a talk abstract can be reviewed unless the level of the topic is also included, along with the target audience (Administrators, TSQL Developers, etc).

sql_butterfly (1/23/2011)

---

Hello Sir, its not like I didn't give it a try. I read a lot and tried lotz of options and tested them as well. However whatever I have...

sqldba_icon (1/20/2011)

---

I would like to know from other DBA's on how do they manage execution plans for procedures.

i) i have a procedure when it is executed for the first...

sudhakara (1/22/2011)

---

Hi,

Am Getting alert message from third party monitoring tool saying that blocked process reaches 99% on the ms sql server 2005. but there is no blocking on the server...

a) the BEST way to learn performance analysis and tuning is to...

moosamca (1/21/2011)

---

1) you say you "got what you expected" after partitioning. what exactly was that?

We had slowness in one module which user pull the data and load in a grid,...

I beat it into the heads of all my client's staff (and SQL Saturday attendees) to ALWAYS use the correct datatypes in ALL scenarios. 🙂

1) http://www.pragmaticworks.com might have a tool to help with this.

2) please take a look at ola.hallengren.com for a FREE suite of scripts to help you move away from maintenance packages...

ravisamigo (1/20/2011)

---

Sorry for the late reply.

Thanks of your valid suggestions and help !!

Is there any impact to database if we do the index rebuild simultaneously/parellely except the performance issue means...

1) you say you "got what you expected" after partitioning. what exactly was that?

2) how exactly are you using the given UDF? as direct output from a select statement...

I didn't dig deep into this but I have seen this pattern many times in the past. Since you say the run time goes up a LOT as total...

You are going about this the wrong way. What is MORE important (usually) than a single bad plan is how bad things are IN AGGREGATE. Which is more...

Incorrect. Per BOL:

DISABLE

Prevents lock...