Forum Replies Created

Viewing 15 posts - 37,801 through 37,815 (of 49,552 total)

  • RE: SQL script to Restore a DB to standard starting point for Test purposes

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749512-357-1.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

    July 9, 2009 at 2:14 am

    #1022210

  • RE: SQL script to Restore a DB to standard starting point for Test purposes

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749512-357-1.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

    July 9, 2009 at 2:14 am

    #1022209

  • RE: Growing log file...

    Try switching to bulk-logged recovery

    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

    July 9, 2009 at 2:12 am

    #1022208

  • RE: Growing log file...

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749686-146-1.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

    July 9, 2009 at 2:11 am

    #1022207

  • RE: Execution plan

    hi_abhay78 (7/8/2009)

    Gail, the number of therads that are working are 8 but the 9th one will be the one consolidating the records and giving the output .

    So 0 through...

    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

    July 9, 2009 at 1:56 am

    #1022199

  • RE: sql sever logins

    You would change a NT password in windows, not SQL

    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

    July 9, 2009 at 1:40 am

    #1022192

  • RE: sql sever logins

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749930-146-1.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

    July 9, 2009 at 1:38 am

    #1022191

  • RE: sql sever logins

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749930-146-1.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

    July 9, 2009 at 1:38 am

    #1022190

  • RE: sql sever logins

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749930-146-1.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

    July 9, 2009 at 1:38 am

    #1022189

  • RE: logins

    Look up ALTER LOGIN in Books Online

    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

    July 9, 2009 at 1:37 am

    #1022185

  • RE: logins

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749935-146-1.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

    July 9, 2009 at 1:36 am

    #1022183

  • RE: SQL script to Restore a DB to standard starting point for Test purposes

    If you're using Enterprise or Developer edition, create a database snapshot before the test starts and restore the database from the snapshot afterwards.

    If you're using standard edition, I would take...

    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

    July 8, 2009 at 1:28 pm

    #1021875

  • RE: Calculating Decimals when dividing whole numbers

    Not sure why the last is returning decimals, but the reason all the earlier ones are not is because you're dividing two ints. The result of that is also an...

    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

    July 8, 2009 at 10:15 am

    #1021830

  • RE: Execution plan

    Matt (7/8/2009)

    GilaMonster (7/8/2009)

    Matt, any reason for the TOP (100) PERCENT?

    No reason, why, could it be causing a problem?

    No, but they're completely unnecessary. That construct's usually the sign of someone...

    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

    July 8, 2009 at 10:02 am

    #1021824

  • RE: SQL Architecture Articles

    ChandraMohan Nandula (7/7/2009)

    Logical design and physical design. When we have articles for reporting services architecture why cant we have for sql server.

    Probably because no one wants to write them. Want...

    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

    July 8, 2009 at 10:01 am

    #1021823

Viewing 15 posts - 37,801 through 37,815 (of 49,552 total)