Exactly thats what I did and it worked..Thanks anyways

I think I figured it out.

Thanks GUys

Hope this helps:

http://blog.sqlauthority.com/2008/02/11/sql-server-2005-find-unused-indexes-of-current-database/

http://blog.sqlauthority.com/2011/01/03/sql-server-2008-missing-index-script-download/

Thanks. I am using a XML config for now. Everytime i get a request i am entering the new values and running the job.

I think once you specify the SMTP server name/Ip address it should use the SMPT server.

That depends again. The difference could be anytime between a day to 15 minutes. So Parameter1 takes 2011-12-15 10:30:00 and parameter2 takes 2011-12-15 15:00:00. In this case the difference is...

its on demand basis.

I am not using the execute sql here. The package selects the data and outputs to a flatfile. I am using the OLEDB Source and Flat file destination. I am...

Also, at the time of adding variables in the "set query parameters" dialogue box for the type datetime, the "Add variable" dialogue box requests me to enter a value for...

fromtimestamp, totimestamp they are of type datetime.

Thanks for the input Michael. Yes I have enable the RCSI on this database. However I am still seeing deadlocks but not the same ones. This time its a different...

Hi all,

I thought to run the victims (EF Generated SQL SELECT queries) through the DETA and see if it recommends any indexes. As expected DETA suggested that there will a...

I am still seeing the deadlocks: Please find the error log trace below:

deadlock-list

deadlock victim=process4df048

process-list

process id=process4df048 taskpriority=0 logused=0 waitresource=RID: 6:1:440021:29 waittime=1397 ownerId=18465075 transactionname=SELECT lasttranstarted=2011-12-07T14:17:45.240 XDES=0x80015920 lockMode=S schedulerid=4 kpid=268 status=suspended spid=144 sbid=2...

Thanks for the reply Kevin. Per michael, I have changed the isolation level from Read Committed to Read Committed Snapshot (although I dont think I have enabled row versioning). I...

Thanks for your reply michael.