Why you can't prepare task correctly?

My answer was right compared to prepared options.

I want my point !!!

Can you prepare task correctly? 🙁

Hi,

where're correct answers? 😉

Tx

SQL Noob (4/2/2009)

on the publisher you run a query and you get an index scan

same query on a subscriber and you get an index seek. the publication had been recently...

I misunderstand what do you mean with the statistics problem. Could you write more details about it?

I don't like to use hurting performance at any time therefor we changed model.:-)

Tx for your help. We changed model and solved problem.

But still I'd like to know if somebody knows how to makes compensation for FORCESEEK in 2005 or 2000.

Perhaps you could tweak query and indexes so that hints are not necessary. Post query, index definitions and exec plan here if you want a hand.

query = view

im trying use...

yes, im sure 😎

i tried SQL used for query...

I know that FORCESEEK is available in 2008, but I need it in 2005 😉

When I use SQL Function REPLACE, I have to create function or procedure. I know about this way, but I don't want to use it.

It's a pity that SQL Server...

We need the same decimal symbol at different databases, but we can't set up or modify regional option.

I'm trying to solve this problem with database settings.

Hi,

that sounds good. I'm trying.

Tx