Forum Replies Created

Viewing 15 posts - 25,591 through 25,605 (of 49,552 total)

  • RE: Database restore

    Jim Murphy (6/9/2011)

    Yes. Thanks Gail. What I was trying to convey was if a Login named AppUser is created on one server, and an AppUser login is created on another...

    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

    June 10, 2011 at 3:36 am

    #1336849

  • RE: SQL Server has encountered 16 occurrence(s) of cachestore flush

    kvr1985 (6/9/2011)

    But i'm getting dialy same information from error log.

    Yes, you will because every single restore you do will clear the cache. Hence those messages are totally normal on a...

    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

    June 10, 2011 at 3:36 am

    #1336848

  • RE: How to get the bottom 10 values in SQLsERVER

    Please don't post in all caps. It's the online equivalent of shouting at people.

    SELECT TOP (10) <column list>

    FROM <Some tables>

    ORDER BY <column that defines the required ordering> DESC

    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

    June 9, 2011 at 3:41 pm

    #1336755

  • RE: Convert integer

    Hang on... They don't like big numbers so you're using a number that's in the general vicinity of a billion billion (1018) What am I missing here?

    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

    June 9, 2011 at 2:12 pm

    #1336712

  • RE: Another Count question

    SELECT i.name, Count(*) as Total

    FROM (SELECT Guid, Name FROM vRM_Computer_Item WHERE ('%'='%' or LOWER ([Name]) LIKE LOWER ('%')))i

    JOIN dbo.Inv_Installed_File_Details fd

    ON fd._ResourceGuid = i.Guid

    where fd.name = 'catalog.dat' and Path not 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

    June 9, 2011 at 2:08 pm

    #1336708

  • RE: Simple Recovery Model

    Make sure you schedule log backups

    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

    June 9, 2011 at 1:47 pm

    #1336700

  • RE: Convert integer

    Wouldn't an identity column be easier? Or even a GUID?

    Why this convoluted approach?

    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

    June 9, 2011 at 1:46 pm

    #1336699

  • RE: Database restore

    Jim Murphy (6/9/2011)

    Database Users are hooked to a server Login's SID (security Identifier). SIDS are unique to the server.

    Not really... They won't match if auto-created, but they're not unique...

    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

    June 9, 2011 at 1:44 pm

    #1336698

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/9/2011)

    Clearly not a BS, he's still in CS101! He'll likely end with a BA or an AA if he finishes at all. 🙂

    He claimed it wasn't homework, that...

    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

    June 9, 2011 at 1:39 pm

    #1336694

  • RE: Are the posted questions getting worse?

    Jim Murphy (6/9/2011)

    To avoid Paired Posting (concurrent posters typing answers to the same question with neither holding a thread-lock with their respective WaitStats being either PageTypeIO or CXHeadSpace), I've...

    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

    June 9, 2011 at 1:37 pm

    #1336691

  • RE: Convert integer

    Ok, what's the point here?

    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

    June 9, 2011 at 1:19 pm

    #1336677

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/9/2011)

    Steve Jones - SSC Editor (6/9/2011)

    Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or discussion seemed to...

    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

    June 9, 2011 at 1:15 pm

    #1336672

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/9/2011)

    Plenty, at least until you threw him across the room.

    I dunno. It's easy to forget there's a real person on the other end of 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

    June 9, 2011 at 1:11 pm

    #1336669

  • RE: what is the website to know all the latest updates to follow up about SQL Server 2008 R2?

    http://blogs.msdn.com/sqlreleaseservices/default.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

    June 9, 2011 at 1:03 pm

    #1336658

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/9/2011)

    Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or discussion seemed to be...

    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

    June 9, 2011 at 1:02 pm

    #1336657

Viewing 15 posts - 25,591 through 25,605 (of 49,552 total)