Forum Replies Created

Viewing 15 posts - 406 through 420 (of 479 total)

  • RE: Largest Unit

    Steve Jones - Editor (4/4/2008)


    Easy there. I let this one go, knowing it didn't really store everything, but that it would be a bit fun and I'd never heard of...

  • RE: Multiple Personality

    DEC ported VMS to the Alpha and that used 4 "modes" (kernel, exec, super and user) so implementing 4 "rings" on Alpha for NT shouldn't have been a problem. I...

  • RE: Largest Unit

    Another poorly thoguht out and wrong question.

    As mentioned, 1000^8 <> 1024^8. 1Yb (Yottabyte) is not the same a 1Yib (Yobibyte, see http://en.wikipedia.org/wiki/Kibibyte). In fact, even the article referenced http://en.linuxreviews.org/Yottabyte points...

  • RE: ORDER BY

    Extended summary:

    majorbloodnock (4/1/2008)


    1. There are practical version differences between SQL2K and SQL2K5 regarding T-SQL handling.

    2. If you work on "theoretically correct" and don't then test, you'll get caught out at...

  • RE: SQL Server 2005 SP3

    Ignacio A. Salom Rangel (3/30/2008)


    How many votes we need to get Microsoft to do something?

    How long is a piece of string?

  • RE: ORDER BY

    And there was I thinking that this was a nice simple question about one of the many pitfalls of using *, and suddenly find it's also a compatibility issue!

    Once again,...

  • RE: SQL Server 2005 In-Place Upgrade Versions

    A better way to ask the question would have been...

    Which of the following cannot be upgraded the SQL Server 2005:

    O SQL Server 2005 RTM

    O SQL Server 2000 SP4 or later

    O...

  • RE: Bad Automation

    john g (3/27/2008)


    Pet Peeve on...

    Would it be difficult for MS to give the option whether or not to allow other windows to grab context from the current one?

    Back in the...

  • RE: SQL Server 2005 In-Place Upgrade Versions

    Actually, I thought it was poorly worded in a different way.

    To me, the phrase "Only SQL Server 2000 SP3 or later" implies that SQL Server 2000 SP4 is included. So...

  • RE: SQL Server 2005 SP3

    Adam Clark (3/25/2008)


    There is a SQL 2005 SP3, it's called SQL 2008!

    Unfortunately Microsoft don't view it that way and ask for a new license fee!

  • RE: XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

    Does anyone know whether the XML or T-SQL count() functions are equivalent in execution, or is one more efficient than the other.

    Is there any significant difference between...

    SELECT

    ...

  • RE: Bad Automation

    I've come across a several applications which open dialog boxes and assume context. Also, as well as Symantec, the ZoneAlarm firewall uses a 'Do you want to reboot' box with...

  • RE: Precedence

    kevriley (3/12/2008)


    yes but the precedence defines the numerator and denominator

    in a world without precedence rules, 10/5*2 could be seen as

    10

    ---- = 1

    5*2

    or

    10

    -- *2 = 4

    5

    No. 'Precedence'...

  • RE: Precedence

    kevriley (3/12/2008)


    Derek Dongray (3/12/2008)


    PS: I assume everyone agrees that multiply and divide are the same precedence so haven't included division.

    Strictly speaking multiplication and division don't have the same precedence, it...

  • RE: Precedence

    Todd Heidesch (3/12/2008)


    Could anyone verify this with an example?

    Unless I'm reading it wrong, this author seems to think otherwise about modulo:

    http://www.informit.com/library/content.aspx?b=STY_Sql_Server_7&seqNum=117

    Yes. They clearly say modulo is done first, and they...

Viewing 15 posts - 406 through 420 (of 479 total)