Forum Replies Created

Viewing 15 posts - 22,396 through 22,410 (of 49,552 total)

  • RE: License By Core

    Andeavour (11/9/2011)


    Is this definitely a given, or just a rumour?

    Definite given.

    How sure are we that Microsoft is going to slit SQL's throat like this?

    Speak with your MS rep (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
  • RE: alter index rebuild or reorganize?

    Ninja's_RGR'us (11/9/2011)


    GilaMonster (11/9/2011)


    Ninja's_RGR'us (11/9/2011)


    Ya but what does he know???

    I'm resisting the urge to say something that would get me into trouble... 😀

    It's not like being a super mvp 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
  • RE: alter index rebuild or reorganize?

    p.s.

    Dev @ +91 973 913 6683 (11/9/2011)


    obetween 5% and 30% logical fragmentation, reorganize it (using DBCC INDEXDEFRAG or ALTER INDEX ... REORGANIZE)

    omore than 30% logical fragmentation, rebuild it (using DBCC...

    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
  • RE: alter index rebuild or reorganize?

    Ninja's_RGR'us (11/9/2011)


    Ya but what does he know???

    I'm resisting the urge to say something that would get me into trouble... 😀

    It's not like being a super mvp and MCM means...

    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
  • RE: alter index rebuild or reorganize?

    As Paul said:

    They're a good starting point to work from.

    <snip>

    They're not set in stone - they're a big generalization, and there are a ton of other factors that may affect...

    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
  • RE: How can I tell if my database has Implicit Transactions On?

    No such option as Ansi Settings. The various Ansi set options and implicit transactions are client settings. They're set (or not) when a client connects.

    There's an sp_configure setting (user options)...

    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
  • RE: Error 9002: The Transaction Log for MSDB database is full.

    forsqlserver (11/9/2011)


    Initially Should I added new log in msdb and master databases in place of rebulid?

    Rebuild is for when the databases are damaged and unusable (or similar disasters) a full...

    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
  • RE: alter index rebuild or reorganize?

    http://sqlskills.com/BLOGS/PAUL/post/Where-do-the-Books-Online-index-fragmentation-thresholds-come-from.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
  • RE: [Just For Laugh] Why only 2 Cents?

    http://www.google.com/search?q=%22English+sayings%22+two+cents%22

    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
  • RE: BACKUP/RESTORE issue...

    Incorrectly configured antivirus perhaps? It's the main cause of problems like this.

    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
  • RE: Memory usage

    Joy Smith San (11/9/2011)


    What if some application ask for more memroy and SQL doesn't need any memory at that time ?

    Then the application asks the OS for memory. 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
  • RE: Memory usage

    Joy Smith San (11/8/2011)


    Is that SO.?

    Yes.

    I was under the impression that SQL Server manages memeory automaticaly when Min and Max memory are not set. When it doesn't need 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
  • RE: Error 9002: The Transaction Log for MSDB database is full.

    Dev @ +91 973 913 6683 (11/9/2011)


    Snippet from your post... Errors & respective suggestions by SQL Server itself.

    Except that so much has been done here (rebuild of system DBs 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
  • RE: How to find ALL SQL servers and their edition

    Have a look at MAP (Microsoft assessment and planning toolkit). Free download that will find all sorts of things about what's running on your network.

    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
  • RE: Error 9002: The Transaction Log for MSDB database is full.

    No idea, never used TFS. Maybe ask that on a TFS forum or with TFS support?

    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

Viewing 15 posts - 22,396 through 22,410 (of 49,552 total)