I was thinking to convert this T-SQL based system to SSIS solution using Maintenance Plan Task components. I haven't done much research on it but seems like doable.

Do you...

Thanks for the reply.

We are actually doing what you suggested and we are controlling these individual scripts on all the server that are run by schedule jobs, through a dedicated...

Thank you guys. it is fixed!!!

We are importing data as "Select * into....." through sql script which we run in SSIS. For remote server properties, connection timeout and query time...

More details please....

Thank you guys.

This is first project of this size for us. We do not have any stats yet. We are changing back end from Oracle to SQL Server for a...

Steve Jones - Editor (8/19/2010)

---

The optimizer examines a bunch of plans, tries to pick the best one. You might get different results at different times depending on data changes, statistics,...

Finally we had meeting with our developers. They showed us how the users actually select options from the front end. They have limited control over forcing users to select elements...

Thanks Chris...let me go through it.

Thanks

Thanks for the replies guys.

While waiting on the reply, I created this small script and it proves what I assumed. The results are different:

create table #a (x int, y int)

create...

try this....I got it from this gentleman (http://www.sqlservercentral.com/scripts/Index+Management/31800/[/url])

-- Select all table names, their individual indexes with keys, description

-- and disk size in MB into a temporary table.

SET NOCOUNT ON

SET...

This might be a good start...

http://www.xdevsoftware.com/blog/post/Query-Active-Directory-from-SQL-2005.aspx

Is it possible for you to share the objective of the requirement?

By the way LiteSpeed 5 and above can do the job. www.quest.com

Are you a database administrator? Do you have permissions on all the database on the instance?

Try this one

http://support.microsoft.com/kb/822101

Dave's query should improve the results....