If @largev would be declared as char(8000) it would always contain the value it was initially set to (probably with a lot of spaces padded to the right).

declare @a char(8000)

set...

Well, unfortunately I cannot say much more than I get the same result. But I have not really looked into the new features regarding schemas and principals yet, so I...

No, I meant like Developer Edition, Enterprise Edition, Express Edition etc.

Steve, lately though I have been getting a lot of OutOfMemory exceptions. Something you are aware of?

At the risk of restating what the other guys said (but I do not think it came out 100% clear).

There is no contradiction. What #2 actually says is that if...

In the default isolation level (READ COMMITTED) read locks (or shared locks as they are called) are not held when the read is finished. The transaction does not do any...

Databases->some database->Programmability->Stored Procedures

Sorry, didn't see this earlier.

Which version are you using? I'll try it when I get home tonight (9 hours from now).

Well, I am not sure exactly what you mean by "coupled with". In the installation for Visual Studio 2005 Beta 2 you can choose to install SQL Server as well....

btw:the only think i learnt from my Sweden trip was "jag talla inte svenska" (splng ??)

Almost. "talla" should be "talar".

Got this in your private message. Please keep the discussion here, that way all members can participate and help out.

How will I know if a table is 'pinned' in memory

Use...

Ok, good, then my English was not as bad as I feared.

If the database is not used it will not require a lot of memory. BOL states that each open database uses 2,880 bytes. Unless any tables in it are pinned...

Note that if you made the columns char(500), then regardless of the string length, 500 bytes is always occupied and you could not insert rows into the table (Remi: do...

Vladimir, the 'folks that you know' are dead wrong. In general, the correct advice is to always create objects in the dbo schema. See Andy Warren's article Worst Practices...