The best way is to create a job which calls the stored procedure and schedule every week. Here is the stored procedure. This SP will store unused indexes in the...

Thanks guys,

Appreciated.

Wish, I had three eyes, looks like two eyes are not enough.

Thanks guys.

Solved the issue. One of the table was highly fragmented and did the rebuild and query is working fine.

Thanks guys,

Update statistics is the part of my database plan so it's uptodate. Data volume is same because it's running before, Nothing has changed.

The wierd thing is that when I...

Wow. That is pretty faster. I will use the one in the article.

Thanks man

How about when database is in a recovery mode or if we are restoring database. will it fill the transaction log file. ?

I agree but don't you think that if backup and data loads are running at the same time then it will fill the transaction log big time.

I think backup...

Msg 7403, Level 16, State 1, Procedure sp_tables_ex, Line 41

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I've searched the web and see this is an issue with the 64...

when I run following which you have mentioned, I get following error

sp_Tables_ex txtsvr

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

Sorry about the last reply. I totally screwed up the english.

here is the updated reply

We cannot do the remote link from Cache database to sql server. as far as I...

We cannot do the remote link from Cache database to sql server. as far as I know there are no drives avaiable for that and also it's a big system...

Let me expain our process. May there there is another way to do that.

- We run nightly job which converts data from Cache database and to flat files.

- We run...

You are right. Variable was not defined as a package level. I defined it as a package level and it's working fine.

Thanks buddy.

I really like what Pablo Picasso has said.

Thanks Stephen for sharing

Pablo Picasso said, "Good artists borrow but great artists steal".