Forum Replies Created

Viewing 15 posts - 406 through 420 (of 480 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...

    Derek

  • 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...

    Derek

  • 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...

    Derek

  • 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...

    Derek

  • 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?

    Derek

  • 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,...

    Derek

  • 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...

    Derek

  • 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...

    Derek

  • 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...

    Derek

  • 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!

    Derek

  • 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

    ...

    Derek

  • 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...

    Derek

  • 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'...

    Derek

  • 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...

    Derek

  • 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...

    Derek

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