any DTA advise must be interpreted and tested before you deploy it.

You may even see quit duplicate indexes advised;

TheSQLGuru (6/10/2009)

---

I believe you are mistaken if you think that MS wasn't working on SQL Server 2008 in late...

I was still searching to get things back on track ... and got to the 32-bit issue after a while.

Thanks.

kittu123 (6/11/2008)

---

Thanks for all the suggestions. Finally I find the reason for failing. It is alias issue on X64 bit connecting to 32 bit.

Initially I created on only Alias...

Hi Alif,

Did you ever got this issue solved ?

I'm having issues exporting to access.mdb with SSIS sql2005 x64 EE.

It cannot be sql2008 ...... the feedback registration date is 11/26/2006

That's normal.

SQLServer will only wait for its standard timeout value of time.

The OS will still complete the extention after sqlserver has raised its error.

marees.inspire (6/10/2009)

---

Hi All,

When i am executing the following query

select count(*) from LinkedServer.SourceDatabase.dbo.sourcetable

It is running more than 3 hours to complete...

Pls let me know why this scenario happening...

Thanks in...

We use the same attitude Grant Fritchey posted.

To support your "support teams" requirements to be able to restore any backup on any given time and database, I would provide them...

Without knowing the tb / ix definitions and stats, i would say to modify all in-lists to @temp objects and rewrite to join with those ! (of use a split-function...

Hmm ... Books online is a good resource to figure this out.

But anyways...

If you can, create a last Log backup !

then:

hmm ...

1) restore the latest FULL backup with...

You should install SSIS server components to schedule the package!!

Apparently adding SQL2008 (devedtn + bids) messed up my settings.

I'll have to figure out a workaround.

This kind of message also occurs if sqlserver cannot take the extend of a db file with a timeout periode.

The extend will still be taken by the os, but sqlserver...

Jeffrey did a good job explaining some of the most primary hits most of us suffered with 64-bit. 😎

One thing I would like to add: Don't enable AWE ! 64-bit...

If I'm correct this will no...