Great, thanks - I knew there was the option, I was just looking in the wrong place!

Thanks for the replies...

Since removing the WHERE clause from the view, the execution plan is now showing:

RID Lookup

Cost 14%

No of Rows 34

Query completion: 112 ms

Adding the where back into place,...

Hi,

Thanks for you questions... Your 1st question has actually made me realise the issue!

The view actually looks like:

SELECT t1.ID,

...

Hi,

Thanks for the replies.

My next question is, should I apply the index to the table or is it better off having the index on the view that is...

Thanks ColdCoffee - that's perfect! 🙂

Can use this in a couple of other places so your help is very much appreciated

Hi,

The users are already set-up to inherit the roles from the database role as I stated in the original post.

I do not want to set permissions on a stored...

Thanks a lot, managed to set up the user.

On a separate note, is there anywhere that I can see all the explicit permissions and what they allow the user to...

try breaking down the query into 3 separate queries and then summing the three counts.

OR statements should never be used unless completely necessary.

GilaMonster (7/14/2009)

Hang on...

Do...

Hi,

Did a bit more research and it was quite a simple fix in the end... Just amended the publisher properties > articles to not replicate delete commends...

Hi crever,

I watched your video on dealing with errors on text files and I found it really useful. I have implemented a similar process into our package, i.e.

Flat...

Hi, I managed to get this to work so thanks for the help.

One final question, how do I log the data that failed to import?

What I want to...

We've managed to remove half of our indexes which has reduced the time the imports take considerably... So thanks for the help.

As for sql performance tuner, I haven't had time...

That's fantastic - exactly what I needed...

We're only a small company and only have 2 developers, no DBA's so have a hole in our knowledge when it comes to...