Forum Replies Created

Viewing 15 posts - 41,581 through 41,595 (of 49,552 total)

  • RE: Dead lock

    arup_kc (1/19/2009)

    We have identified the objects where dead lock is hapening. While deleting in one table and simultaniously updating and inserting it happens.

    Please post the code involved, the table...

    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 19, 2009 at 4:21 am

    #929087

  • RE: clientprocessid in profiler

    SQL only knows what machine initiated the database connection. In the case of a web application (asp, asp.net, php), that's the web server. If you want to trace who's connecting...

    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 19, 2009 at 4:16 am

    #929083

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/18/2009)

    Who knows how good it will be? I have a basic outline of the "series" it is based on a Profiler presentation I did at the Orlando...

    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 19, 2009 at 1:17 am

    #929056

  • RE: Object does not exist error is getting if VIEW DEFINITION denied

    What do those few stored procs that fail do that the ones that work don't? Access the system 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 19, 2009 at 1:12 am

    #929055

  • RE: SQL Server Assertion: File:

    uofmoo (1/19/2009)

    Advice?

    Troubleshooting help?

    Call Microsoft's customer support. Especially since this is a business-critical system

    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 19, 2009 at 1:11 am

    #929054

  • RE: clientprocessid in profiler

    nashreen.mosaheb (1/19/2009)

    But in SQL Profiler 2000, you could filter your query by the client's hostname.. I can't find how to do that with the SQL Server 2005 version(am using this...

    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 19, 2009 at 1:06 am

    #929050

  • RE: Need output as 1,2,3,...10

    Jeff Moden (1/18/2009)

    Other than a firedrill on this forum, when have any of you actually had to concatenate data in SQL Server in such a fashion in production?

    Couple times, but...

    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 19, 2009 at 12:06 am

    #929037

  • RE: clientprocessid in profiler

    Client process won't give you the machine. It gives you the processid on that machine. For the machine, use the hostname column.

    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 18, 2009 at 11:59 pm

    #929034

  • RE: VIMP*Backup

    kiransuram19 (1/18/2009)

    The ldf file size is 9.5GB and mdf file allocated size is 4.5 GB( We can assume that data is 15.6 MB in mdf) But when I backup 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 18, 2009 at 11:56 pm

    #929033

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/18/2009)

    I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...).

    Ah. I was considering writing on server-side...

    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 18, 2009 at 3:32 pm

    #928976

  • RE: Eliminate Duplicate Records

    Use something like this as the basis for the view.

    SELECT *

    FROM

    (SELECT MAX(OrderNO) as MaxOrder, itemID, UOM FROM SomeTable GROUP BY ItemID, UOM) Qualifying

    INNER JOIN SomeTable...

    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 18, 2009 at 3:30 pm

    #928974

  • RE: Creating indexed views

    pat (1/18/2009)

    Names must be in two-part format.

    As the error says. 3-part naming is also not allowed. Hence, only objects within the same database.

    Edit: There's a long list of restrictions...

    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 18, 2009 at 2:14 pm

    #928967

  • RE: Why do people need to do this?

    Garadin (1/18/2009)

    Is that ever the case though? =).

    Maybe. There's more than one company I know where the access control doesn't allow two entrances one after the other. If you swipe...

    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 18, 2009 at 1:26 pm

    #928962

  • RE: Creating indexed views

    A normal query isn't schema bound.

    A simple view is not schema bound.

    Both of those will run fine when referencing another server.

    The restriction is that you cannot reference a remote...

    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 18, 2009 at 1:05 pm

    #928959

  • RE: Corrupt Table

    Yeah, true.

    Even so, the only extra checks (afaik) that are added once checkdb with data purity has run successfully are the ones that you turn on by adding 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 18, 2009 at 1:03 pm

    #928958

Viewing 15 posts - 41,581 through 41,595 (of 49,552 total)