Forum Replies Created

Viewing 15 posts - 26,461 through 26,475 (of 49,552 total)

  • RE: Memory Utilization of individual db instances of a DB server

    sashikanta.mishra (4/28/2011)

    @Brian : Thanks for the same. It gives me the result of memory pages. But this will not let me know whether my database is actually using the memory....

    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

    April 28, 2011 at 4:14 am

    #1317128

  • RE: Create Login?!

    Two comments unrelated to the security aspect...

    begin tran srvr;

    set @sql = create login ' + @ip_newuser + ' with password = ''password'' ' ;

    exec (@sql);

    There's no use in naming transactions...

    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

    April 28, 2011 at 1:49 am

    #1317074

  • RE: Memory Utilization of individual db instances of a DB server

    Ok, now I'm confused. SQL 2000 as in your first post or 2005 and 2008 as in your second?

    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

    April 28, 2011 at 1:41 am

    #1317071

  • RE: Index fragmentation

    Alter index REbuild. Compat level doesn't change that DBCC DBREINDEX is deprecated.

    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

    April 28, 2011 at 1:40 am

    #1317070

  • RE: Memory Utilization of individual db instances of a DB server

    No need to repost, I have asked the mod to move this thread.

    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

    April 27, 2011 at 11:58 pm

    #1317044

  • RE: Index fragmentation

    Compatibility level is 80.

    Run from master and pass the DB_id in.

    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

    April 27, 2011 at 11:57 pm

    #1317043

  • RE: light weight pooling greyed out

    If you still decide that you need to, try in code rather than GUI.

    exec sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    exec sp_configure 'lightweight pooling', 1;

    GO

    RECONFIGURE;

    GO

    It's greyed out on my instance too. Could...

    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

    April 27, 2011 at 11:45 pm

    #1317042

  • RE: Not Sorting in Ascending Order (sql server 2005)

    Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951

    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

    April 27, 2011 at 5:18 pm

    #1316974

  • RE: Are the posted questions getting worse?

    Seeing as people like the stuff (for whatever reason), here's an old, humorous piece, written as an argument against critical fumbles rules in roleplaying (written shortly after our 1st level...

    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

    April 27, 2011 at 4:19 pm

    #1316955

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/27/2011)

    GilaMonster (4/27/2011)

    Brandie Tarvin (4/27/2011)

    GilaMonster (4/26/2011)

    I don't do epic verse.

    Though... (read attached at your own risk, very amateur attempt)

    Wow. Gail, I loved the ice spirit story. That's beautiful and deserves...

    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

    April 27, 2011 at 4:14 pm

    #1316953

  • RE: SQL Server2008 producing same result set but with changed in order seq after upgrading from sqlserver2008

    Post table definition and query.

    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

    April 27, 2011 at 2:12 pm

    #1316887

  • RE: Index Corruption Stack dump but no corruption found

    shaneat (4/27/2011)

    I am going to try checkdb with REPAIR_REBUILD to see if that fix it but will take some time to get schedule maint time to run this in production.

    if...

    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

    April 27, 2011 at 1:56 pm

    #1316874

  • RE: Less Pay, More Convenience

    Ninja's_RGR'us (4/27/2011)

    exec sp_update_resume

    exec sp_distribute_resume

    exec sp_bye_bye_<moronic>_boss(es)

    GO

    Select employment_type, payment_status, contract_prognosis FROM MoronicClient

    Contract Awaiting Feb payment Poor

    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

    April 27, 2011 at 12:06 pm

    #1316806

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/27/2011)

    GilaMonster (4/26/2011)

    I don't do epic verse.

    Though... (read attached at your own risk, very amateur attempt)

    Wow. Gail, I loved the ice spirit story. That's beautiful and deserves a short...

    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

    April 27, 2011 at 12:06 pm

    #1316805

  • RE: Less Pay, More Convenience

    Peter Maloof (4/27/2011)

    GilaMonster (4/27/2011)

    Any wonder she doesn't let me work away from the office?

    If you were a little under the weather, would your manager expect you to:

    A. Telecommute, and do...

    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

    April 27, 2011 at 11:36 am

    #1316787

Viewing 15 posts - 26,461 through 26,475 (of 49,552 total)