sure Jeff, I will 😉

• This reply was modified 5 years, 3 months ago by  Mahesh Bote.

I wish I could, but those are nested views. Anyway I will try to re-write the views. Thanks for all your inputs

Thanks Jonathan. query we have will run always with same set of parameters and this query is in PROD. so I can't run

DBCC FREEPROCACHE

Thanks Jonathan for the suggestion. I had a look at the Statistics and found they are very much updated with current date. I found difference in Actual Execution plan when...

• This reply was modified 5 years, 4 months ago by  Mahesh Bote.

Thanks Y.B.!

Thank you very much for the details, But does it make sense having same columns in "Included" in NC index which are key columns of Clustered Index?

Regards

• This reply was modified 5 years, 4 months ago by  Mahesh Bote.

thank you all for your valuable inputs.

[font="Verdana"]

Or even what you can try is, making a use of "DATA CONVERSION" Transformation. In a Data Conversion Transformation Editor, change the Data Type, i.e. String [DT_STR] TO Unicode String...

[font="Verdana"]I came across with a very detailed example. Please refer : http://stackoverflow.com/questions/7411741/how-to-loop-through-excel-files-and-load-them-into-a-database-using-ssis-package

[/font]

[font="Verdana"]Thanks Gail[/font]

[font="Verdana"]

Hopes you have re-build the non-clustered indexes after creating the clustered one. The reason behind is that...

[font="Verdana"]You can enable the Actual Execution plan and verify yourself

-- Mahesh[/font]

[font="Verdana"]Thanks Gail Shaw, Vedran for your valuable inputs.

@Vedran, ofcourse not. I keep my eyes widely open while writting Insert / Update / Delete :w00t:[/font]

[font="Verdana"]Simply comment out those statements which are returning results 😀

Jokes apart, let us know, what exactly you are trying to do?

Thanks,

--Mahesh[/font]