Forum Replies Created

Viewing 15 posts - 21,316 through 21,330 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/5/2012)

    It's almost like they want to punish you for daring asking for money and making sure you NEVER ever want to go through that process ever gain.

    At least they...

    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 5, 2012 at 10:47 am

    #1429205

  • RE: tempdb file deleted

    What error do you get 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 5, 2012 at 9:39 am

    #1429134

  • RE: Are the posted questions getting worse?

    Cadavre (1/5/2012)

    Sorry, should have said that it doesn't work with IE (well, can't get it to work with 8 or 9). Works in Chrome for definite, and think it...

    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 5, 2012 at 9:37 am

    #1429131

  • RE: Deadlock Issues

    Is the database compatibility mode set to 100?

    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 5, 2012 at 9:23 am

    #1429112

  • RE: tempdb on local or san disks

    Please note this thread is 5 years old.

    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 5, 2012 at 7:26 am

    #1429001

  • RE: How SQL uses Memory

    Ninja's_RGR'us (1/5/2012)

    My guess is that a decent book is at least 1-2 000 hours. I don't think publishing houses will give 100K to write the book ;-).

    Just editing Jonathan's...

    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 5, 2012 at 7:24 am

    #1428998

  • RE: How SQL uses Memory

    Dev (1/5/2012)

    GilaMonster (1/3/2012)

    SQLKnowItAll (1/3/2012)

    lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives....

    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 5, 2012 at 7:21 am

    #1428994

  • RE: Check Expiry date of MSSQL2008

    pallavi.unde (1/5/2012)

    Installed on remote server...

    How can i extend date of expiry??????

    Buy a licensed copy of SQL Server and upgrade.

    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 5, 2012 at 7:16 am

    #1428990

  • RE: Are the posted questions getting worse?

    Desperation or laziness?

    Explain everything about partitioning: http://www.sqlservercentral.com/Forums/FindPost1229215.aspx

    Post on old thread asking how to partition an existing table: http://www.sqlservercentral.com/Forums/FindPost1230706.aspx

    Post on old article asking for script to partition existing table: http://www.sqlservercentral.com/Forums/FindPost1230714.aspx

    Anyone 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

    January 5, 2012 at 7:14 am

    #1428988

  • RE: SQL 2005 SP2 Database Mirroring

    If you're using SQL Native Access Client as a data access library, it includes transparent client redirection, picking up that the principal and mirror have switched. The only thing you...

    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 5, 2012 at 7:11 am

    #1428985

  • RE: db_datareader allow alter permissions

    Can you remove the denys and check if the user still has those permissions?

    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 5, 2012 at 6:29 am

    #1428962

  • RE: Can we implement Clustered Index on Unique key ?

    Reply to what?

    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 5, 2012 at 5:25 am

    #1428927

  • RE: db_datareader allow alter permissions

    Check that the user isn't the owner of any objects (or the owner of the DB)

    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 5, 2012 at 4:50 am

    #1428899

  • RE: How to determine the Log Space

    Please read through this - Managing Transaction Logs[/url]

    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 5, 2012 at 4:30 am

    #1428894

  • RE: Need Details for Database Table partition in Sql server 2005 And 2008 Developer/Enterprise edition

    yo_jain (1/5/2012)

    then after implementing partition over this table ,Do i need to implement partitioned over all the indexes aslo or just only on inxed attached to primary key.

    Both are valid...

    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 5, 2012 at 4:02 am

    #1428877

Viewing 15 posts - 21,316 through 21,330 (of 49,552 total)