Hi there,

I checked the bahavior of varchar(max) in Sql Server 2005. I took the following set of statements.

declare @STR varchar(MAX)

deckare @replicateCount INT

set @replicateCount = 100000

set

Ya you are right, that above for 8000 bytes we need a off row data, we should also turn on the option "large value types out of row". But i...

Hi there,

If you are sure that the length of the parameter @deliverycenter will be less than 8000 characters then use varchar(500). Whilst varchar(MAX) will not affect the performance much, since...

Hi there,

You can use Sqlwb to open management studio. But sometimes if you install sqlserver and Management studio express seperatly you have to use ssmsee instead.

The best way is...

Hi calltoaneesh,

If you execute the above statement then you are trying to create a database locally with database files in a remote machine,

In OSQL you have the switch -S...

I think the ratio of number of rows in the table and the percent specified is also a deciding factor for the number of rows to be returned.

This is...

The tablesample returns a random number every time as the seed used to generate the random number varies marginally everytime, eventhough we say tablesample(10 percent) it will reutrn +1000...

The tablesample returns a random number every time as the seed used to generate the random number varies marginally everytime, eventhough we say tablesample(10 percent) it will reutrn +1000...