Check Performance Event Classes in SQL BOL.

Degree Of Parallelism1 and Show Plan Text are supposed to help, but I have never used them.

For the most they are the same. I do believe Enterprise supports log shipping thou, which is not really replication but is psuedo used as an alternative.

Here however is a...

Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step

Seems to be a deceient book for the beginer which one of my fellow cohorts picked up and is using. I am...

Oh, ok. Then the answer is No. They do not publish suggestion tht had been made. Primarily since as long as you don't know what people are really asking for...

If coming from a client app then have the app do a replace of the ' with '' (two single quotes).

VB

REPLACE(variablename,"'", "''")

C++

cStringVar.Replace("'","''")

Another for SQL

set @param = replace(@param, '''', '''''')

(Note there...

Another thought, do you copy any files down that get deleted during processing? Also, have you run the checkdisk utility (can be found by right clicking the drive, choose properties...

You can do as many join as you need to build a query set. However the more work there is to do the slower it can get, so I suggest...

quote:

---

Have you checked out the BINARY_CHECKSUM() function?

---

Just curious, what would I do with it other...

If this will be the default setting for all future databases set it instead in the model database. Remember when you create a database it is based on the models...

But that only applies to if the variable remians in scope.

TSQL is DROP DATABASE, and if you kill the wrong database you can create issues including killing the server. If you drop the wrong one thou and is not a...

I believe if the datas lenght in the text field is always under 8000 bytes then you can use INSERT...FROM, also I am pretty sure you can use the SQL...

Can you post the query. Also, take a look at the execution plans of both and see if anything specific is happening that is different? Finally, if the views are...

No but this thread would work fine.

First I edited my last statement as it only applies to sp_ items and does not matter it you use the 3 part name. When prefixed with sp_ it will...