You should first make sure that you are still supported when you change the configuration yourself.

Frank

http://www.insidesql.de

I would say that you've included indexes with your import.

There is a different between 'regular' indexes and 'statistics'.

For further explanation on indexes and statistics I suggest reading BOL. Should...

I'm reposting my answer from sql-server-performance.com:

I would not force the query optimizer to do something. Hint is a misleading word in this context I think.

What might seem appropriate for the...

SELECT HOST_NAME()

results in

--------------------

WS110H1009008



(1 row(s) affected)

Frank

http://www.insidesql.de

This link might also help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16321

Frank

http://www.insidesql.de

What are the result of exec sp_spaceused on both db's?

Frank

http://www.insidesql.de

quote:

---

Now I know MS SQL, and I know of the existance of Sybase and Oracle. So what would an open source...

Sorry, you should see something like

DoubleSize  NotDoubleSize 

----------- ------------- 

30          15



(1 row(s) affected)

Frank

http://www.insidesql.de

Edited by -...

Piggy-backing on Phill's answer, this might illustrate it

DECLARE @a NCHAR(15)

DECLARE @b CHAR(15)



SET @a='Why Unicode?'

SET @b = @a

SELECT DATALENGTH(@a)as DoubleSize, DATALENGTH(@b) as NotDoubleSize

Frank

http://www.insidesql.de

Edited by - Frank Kalis...

quote:

---

Don't forget about the problems with Access and database corruption.

If you are sharing an MDB file across the network with multiple...

Does this help

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17563

??

Further explanations you can find in BOL under 'UPDATE'

Frank

http://www.insidesql.de

Try it out.

Works here without any issue. Even with having a relationship

Frank

http://www.insidesql.de

Hi Wes,

great, that's all I need. I don't want to dive too deep into this and leave them with your answer.

Thanks again!

Frank

http://www.insidesql.de

Sorry, typo

Edited by - Frank Kalis on 10/24/2003 ...

Thanks for reply!

I'm not going to decide on this topic.

They just asked me what I think and I said I don't know. But I'm pretty sure they'll get in...

ok, from BOL

quote:

---

System stored procedures are the exception because EXECUTE permissions are already granted to the public role, which allows everyone to...