Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Reclaiming freed space

    I thought that truncate will do the job. Now I know it does not. Good question!

  • RE: T-SQL

    the correct answer is False.

    Even though the local an UTC represent the same time, when you compare them just as datetime with no referece (local or UTC) they are different...

  • RE: Memory Management

    It's been already said:

    from http://www.microsoft.com/windowsserver2003/64bit/x64/datacenter.mspx

    ...(Windows Server 2003 R2 Datacenter x64 Edition supports up to thirty-two CPUs on one server)...

    at least half a point;-)

  • RE: T-SQL 2008

    I agree with anyone saying that either the question or the answer is wrong.

  • RE: Data Type

    you got me!

  • RE: one character of data

    1."[it] will never be a null or an empty space" -> varchar or nvarchar are out of question.

    2.you didn't specify about character set -> I asume the worst and chose...

  • RE: nvarchar

    You got me on this one;-)

    10 pints for Ten Centuries!

  • RE: Maximum instances supported by SQL Server 2008

    I agree with everyone. None of the answers is right, though the first was intended to be the correct one.

  • RE: Take Care of Yourself

    I went the doctor the other day and after going through the whole procedure of invetigating I found out it was nothing to be affraid of and the doctor told...

  • RE: Create Database

    I would rephrase the question:

    is it possible to create a DB with this code?

    The way you put the the question is tricky!

  • RE: Transactions

    following the example from the question the second batch running on a different windows is waiting for the first one: therefore the answer "None of the above"

Viewing 11 posts - 1 through 11 (of 11 total)