Forum Replies Created

Viewing 15 posts - 13,876 through 13,890 (of 49,552 total)

  • RE: Database name is visible but not available.

    Any relevant messages in the error 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

    March 15, 2013 at 1:01 pm

    #1597634

  • RE: Instance won't start after changing Processor Affinity

    GilaMonster (3/15/2013)

    If you want to balance the CPU load of the instances, the windows resource manager's a better choice

    http://technet.microsoft.com/en-us/library/cc755056.aspx

    Firstly you can do more granular limits, second, because if the other...

    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

    March 15, 2013 at 12:54 pm

    #1597631

  • RE: Instance won't start after changing Processor Affinity

    Are those two instances (the ones failing) SQL Express by any chance?

    btw, generally configuring the cores as you tried is not usually a good idea. Those are fairly advanced settings...

    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

    March 15, 2013 at 12:43 pm

    #1597624

  • RE: How to find where sp_spaceused is being executed from?

    Set up a profiler trace or extended events session. If it's running at predicatable times, should be easy to catch

    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

    March 15, 2013 at 10:37 am

    #1597582

  • RE: SQL 2008 - Min and Max server memory

    balasach82 (3/15/2013)

    Reconfirming... so i can give max memory 2147483647 even though i have 4gb memory only. SQL would get memory pressure and page out only if it exceeds 2147483647. 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

    March 15, 2013 at 10:31 am

    #1597574

  • RE: secondary database is sink

    Sink?

    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

    March 15, 2013 at 6:31 am

    #1597466

  • RE: Where is my execution plan?

    syscacheobjects is deprecated, will be removed in a future version, is included only for backward compatibility with SQL 2000 and should not be used. The replacement is the combination of...

    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

    March 15, 2013 at 4:42 am

    #1597415

  • RE: What is a User without a login that cannot login but can be granted permissions used for?

    clintonG (3/14/2013)

    Would this type of login for example be typical for creating a User that gets logged in by Integrated Security but must only be granted permissions to create and...

    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

    March 15, 2013 at 3:59 am

    #1597406

  • RE: restore backup

    Restore somewhere that has 30 GB free, shrink the DB, then move it or backup/restore again.

    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

    March 15, 2013 at 3:54 am

    #1597403

  • RE: Where is my execution plan?

    There are a number of things that cause the plan not to be cached at all. If you want the estimated plan, easiest way is just to use the 'Display...

    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

    March 14, 2013 at 10:42 am

    #1597136

  • RE: a transaction is beeing rolled back for several days

    sql-lover (3/14/2013)

    It was a test machine and have a fresh backup, so I restored from it, but it surprised me that the restart damaged the database.

    The restart didn't damage 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

    March 14, 2013 at 9:31 am

    #1597086

  • RE: Encryption doubts

    winmansoft (3/14/2013)

    What if i use ENCRYPTBYPASSPHRASE to encrypt selected colums? How anyone with admin permission can decrypt it without knowing passphrase?

    If the passphrase is passed to a stored procedure, trivially....

    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

    March 14, 2013 at 9:10 am

    #1597068

  • RE: adding a new not null bit column with default 0

    bugg (3/14/2013)

    That is why I was looking into creating a new table with the addtional column then moving the data etc and finally doing a table rename

    You can do 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

    March 14, 2013 at 9:08 am

    #1597066

  • RE: Creating my first UD

    General rule - format is a display problem, should be done in the presentation layer of the application, not the database server.

    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

    March 14, 2013 at 9:07 am

    #1597065

  • RE: Encryption doubts

    winmansoft (3/14/2013)

    If a user who has access to the database with admin permission then he can take backup and restore database anywhere.

    Correct

    So can i protect the database from being stolen?

    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

    March 14, 2013 at 8:21 am

    #1597030

Viewing 15 posts - 13,876 through 13,890 (of 49,552 total)