Thanks for the explanation and for all the detailed and brilliant knowledge/analysis.

Disclaimer : Please excuse me for the delayed attempt for these questions

I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3 is...

Koen Verbeeck (3/7/2014)

---

Carlo Romagnano (3/7/2014)

---

Koen Verbeeck (3/7/2014)

---

Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.

ps: no actual connections to a certain Grant who is...

Truly, I thought of using temp table but I need everything in a single query.

thanks for the advise

I would like to gain performance also 🙁

Thanks for the reply

select col_1 from table_1

inner join table_4

where table_4.id not in(select parent_id from table_4)

union

select col_1 from table_2

inner join table_4

where table_4.id not in(select parent_id from table_4)

union

select col_1 from table_3

inner join table_4

where table_4.id not...

Thank you all for your responses. As of Now, I have given scripts for rebuilding indexes. Yet to implement this.

There is great learning every day through QOD. Thanks for the question

I also got it wrong after reading MSDN :hehe:.

Thanks grant

using sql profiler

Jeff,

I am sorry if I have confused you.

I still stand on the same point that there are set of update statements in a stored procedure.Due to these updates, CPU is...

hi grant,

I tried with the below query using the reference

http://msdn.microsoft.com/en-us/library/ms189472.aspx

SELECT qs.plan_handle, pvt.sql_handle,pvt.dbid,

(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,

( (CASE...

jeff,

I have re written the query by joining the de norm table in from clause, but the no of

reads and cpu are high with the new query. Old query is...

James,

We are getting nulls for object_name and database_name

Can you please advise on this