Thank you.

In that case, shall we drop the index? If we drop that Index, what will happen?

Those operations automatically use the second Index

Hi Grant,

Thanks for the reply. It is showing the text like create procedure, create trigger and update with where clause

Hi,

Please let me know how to find that queries.

I am coming to conclusion for the difference b/n select * into and Insert into like below

1) select * into #temp from table1 doesn't degrade any performance.

2) Select *...

Ok. Thanks

Ok. Thanks

Thanks Gila.

Please let me know,

Which one we have to consider in query tuning CPU time or total elapsed time? If our modification raise one time and reduce another shall...

Hi Grant,

Thanks for your reply. It looks clear but some confusion is left. For a table, I have several indexes

but two Indexes with similar columns

EX:

Index1

with column1(State), col2(purchaseStatus), col3...

Hi,

You mentioned stats here. How do we know how often we have to update stats. How to find the optimizer is using right stats or not?

Sorry. The topic name is different so I kept in different place.

I thought compare to left outer join, outer Apply is better!

Also when you are looking for performance improvement which one is important?

I mean total elapsed time or CPU time. If...

Hi,

I think I can use outer apply to substitute left outer join, but I am not sure do we need to give column name like join

Suppose in left outer join...

Thanks Grant.

One more doubt. Suppose if I have 2 indexes on a table with almost with similar columns. How can we find which index needs to drop and which index...

Hi,

I am sorry.

Actually that filters are column names ColumnA in tableA=.. and or..

Thanks Gail Shaw.