Forum Replies Created

Viewing 15 posts - 41,656 through 41,670 (of 49,552 total)

  • RE: Systems DB Move

    A quick google search brings up the following page:

    http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 9:22 am

    #928268

  • RE: DBCC CHECKDB marks database SUSPECT

    That's probably it. Are there other data files from the same db on that disk?

    The 'internal' snapshot that checkDB uses is created on the same drives as the data files....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 9:20 am

    #928263

  • RE: distinct view

    You don't need the distinct in that, because of the group by.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 9:13 am

    #928258

  • RE: Top N sub query workaround - Does it exist?

    Ah, that one.

    SELECT productId, productnumber,

    (SELECT top 1 LineTotal FROM Sales.SalesOrderDetail sd WHERE sd.productID = p.productid order by sd.ModifiedDate)

    FROM Production.Product p

    WHERE ProductNumber like...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 9:06 am

    #928250

  • RE: DBCC CHECKDB marks database SUSPECT

    dmc (1/16/2009)

    The transaction rolled forward/back should not be any issue. That is simply the dbcc command getting the database to stable state to perform its actions (or so is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 8:57 am

    #928241

  • RE: Top N sub query workaround - Does it exist?

    Jeff Moden (1/16/2009)

    GilaMonster (1/16/2009)

    If the comparison with the outer query is an equality, the subquery won't be processed row by row.

    I pretty sure it will with an ORDER BY...

    Order by...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 8:50 am

    #928234

  • RE: distinct view

    As the error says, there's no name for the first column. A view needs all columns named.

    ALTER VIEW [dbo].[vwPurchase]

    AS

    Select

    min(pur.InPurchaseId) AS MinPurchaseID,

    ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 8:50 am

    #928231

  • RE: DBREINDEX 500GB DB

    RSingh (1/16/2009)

    Can anyone advise, how long it will take to reindex tables in such a large database?

    How long is a piece of string?

    It depends on the size of the tables...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 7:43 am

    #928144

  • RE: Which SQL would run faster?

    leonp (1/16/2009)

    second .. while i admit to being a little lazy, I do not have access to the database itself that this 'representative query' is to process

    Got a local...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 7:40 am

    #928138

  • RE: Which SQL would run faster?

    Jeff Moden (1/16/2009)

    I'm trying to be as nice as pie... I don't understand why people post code and ask which will be faster... that's pretty lazy...

    Cause it's easier than...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 7:34 am

    #928126

  • RE: Top N sub query workaround - Does it exist?

    They're not processed separately, that's the point. SQL can and does 'de-correlate' the subquery and create an exec plan that processes the inner and outer query together.

    Take this example I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 7:17 am

    #928097

  • RE: Top N sub query workaround - Does it exist?

    Ramesh (1/16/2009)

    Thanks gail, for letting me know about the optimizer and correcting me. One thing, is it do the same in all environments? Or is it dependent on...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 6:48 am

    #928067

  • RE: Internal Table

    CrazyMan (1/16/2009)

    When i tried to apply the CU that MS mentioned, it said that an advanced version is been installed on the machine 🙂

    It's one of the service broker...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 6:46 am

    #928064

  • RE: Database size trouble

    Ramesh (1/16/2009)

    Thanks again Gail, but I was thinking about the shrinking the logs. Does it break the log chain of the database?

    No. Shrinking logs does not break the log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 6:45 am

    #928062

  • RE: Database size trouble

    Ramesh (1/16/2009)

    So, if the database is not in production or you don't need any information from the logs then you can simply hrink the database, and take the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 16, 2009 at 6:18 am

    #928023

Viewing 15 posts - 41,656 through 41,670 (of 49,552 total)