Forum Replies Created

Viewing 15 posts - 181 through 195 (of 216 total)

  • RE: FAST audit of SQL Server licensing?

    If your in-house tool can use other tools then maybe SQL Scan could be used. It is part of the SQL Critical Update Kit and was provided to help...

  • RE: migrating a sql 2000 to a new sql 2000

    Is the server you are migrating to going to have the same name?

    Also is the directory/file structure the same? If it is all you would need to do is...

  • RE: ORDER BY

    No didn't get an oak cross - apparently there wasn't enough clarification of what kind of tree was needed so I got a cross made of leaf nodes from a...

  • RE: ORDER BY

    brewmanz.sqlservercentral (4/16/2008)


    Sadly, our in-the-field knowledge contradicts the poster's limited knowledge of SQL in-the-field even though the answer clearly asks for the in-the-field result of a SQL statement.

    Jeez - you...

  • RE: SQL Server 2005 SP3

    post from Francois Ajenstat (Microsoft)

    http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx

    proclaiming the intention to release SP3 later this year...

    "...Iā€™m happy to inform you that we will in fact deliver an SP3 following the release to manufacturing...

  • RE: T-SQL Query

    Simon Facer (4/15/2008)


    Being a DBA does not make you 'better' than a developer, we are all different parts of the same organization with our own skills and responsibilities.

    The inference that...

  • RE: T-SQL Query

    There is always 101 ways to do anything in t-sql - the trick (or more specifically, the skill) is knowing which is the right way:D

    That's one of the attributes that...

  • RE: ORDER BY

    *raises head above parapet*

    First of all apologies for the late response - I was out of action yesterday.

    I was going to apologize for not being more specific in the question,...

  • RE: Workgroup Edition features

    That's the same link as in the answer explanation šŸ™‚

  • RE: SQL Server Scalabilty - An Introduction

    Richard is right - because clustering is a 'Shared Nothing' architecture - only one node at a time would be able to host a particular database.

    Imagine the extreme scenario where...

  • RE: SQL Server 2005 Best Practices

    Think you are referring to the 'type' column in sys.objects

    From BOL, values for this are

    type char(2) Object type:

    AF = Aggregate function (CLR)

    C = CHECK constraint

    D = DEFAULT (constraint...

  • RE: Precedence

    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

  • RE: Precedence

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

  • RE: Precedence

    The link provided states

    Following is information about arithmetic operators:

    When there is more than one arithmetic operator in an expression, the multiplication, division, and modulo operations are calculated first, followed...

Viewing 15 posts - 181 through 195 (of 216 total)