Forum Replies Created

Viewing 15 posts - 26,026 through 26,040 (of 49,552 total)

  • RE: Is this query right for finding fragmented indexes?

    paul.knibbs (5/19/2011)

    I'm pretty sure the 30% was a ballpark figure that one of the guys who wrote SQL server came up with

    Yup, same with the 1000 page rebuild limit. General...

    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

    May 20, 2011 at 10:13 am

    #1327806

  • RE: Logshipping -- What am I missing??

    Query the backup tables in MSDB (or check the error log). If it says the logs are out of sequence, they are.

    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

    May 20, 2011 at 10:11 am

    #1327804

  • RE: Logshipping -- What am I missing??

    You have another log backup job running?

    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

    May 20, 2011 at 9:08 am

    #1327747

  • RE: Can we set up two mirror databases to one principle server in Mirroring?

    No. One principal, one mirror.

    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

    May 20, 2011 at 8:59 am

    #1327745

  • RE: Transaction Log Woes

    muthukkumaran (5/20/2011)

    Check this article's.

    Truncating and shrinking the transaction log file

    Shrinking log file script

    I Hope someone will help

    It'll help me in making money, I can charge to fix the damage...

    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

    May 20, 2011 at 8:56 am

    #1327741

  • RE: Two questions in mind (for genralized approach)

    Ninja's_RGR'us (5/20/2011)

    I don't know why but I was under the impression that there was a free ebook version of 1 on his books.

    There is. See the Books item in 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

    May 20, 2011 at 8:55 am

    #1327738

  • RE: SQL Class project

    Well firstly you need to USE the newly created DB or your tables go elsewhere, likely master.

    CREATE DATABASE Example

    GO

    USE DATABASE Example

    GO

    CREATE TABLE Product (...

    As for the rest, post the syntax...

    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

    May 19, 2011 at 11:43 pm

    #1327480

  • RE: Find queued ALTER TABLE commands?

    n.heyen (5/19/2011)

    I didn't know that if I take the DB offline and back again the modify will complete. That is certainly good news, I can do that during off hours...

    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

    May 19, 2011 at 11:34 pm

    #1327478

  • RE: Database Kill

    Lee Crain (5/19/2011)

    Restarting SQL Server was my first thought, too. But, what if whatever has stuck the rollback persists when SQL Server restarts?

    Highly, highly unlikely.

    If it does, Gus falls...

    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

    May 19, 2011 at 11:34 pm

    #1327477

  • RE: Complex Case Expression

    http://www.dbforums.com/

    Not being nasty, but you may want to apologise to MM as this likely wasted quite a few hours of his time.

    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

    May 19, 2011 at 11:30 pm

    #1327476

  • RE: any idea about error below restore error

    SQL databases cannot be downgraded, you cannot restore or attach a DB from a higher version to a lower version.

    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

    May 19, 2011 at 2:12 pm

    #1327337

  • RE: sql 2008: Alternatives to "master..spt_values"

    Select ROW_NUMBER () OVER (ORDER BY column_id) AS Number from sys.columns

    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

    May 19, 2011 at 1:04 pm

    #1327314

  • RE: Find queued ALTER TABLE commands?

    Alter table statements are never pending, only running or complete.

    The only alter database that needs a restart of SQL (not reboot of the server) is an alter database ... modify...

    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

    May 19, 2011 at 12:53 pm

    #1327307

  • RE: Access extent and page information of an object

    abygaikwad17 (5/19/2011)

    3. I would still like to know more about pages and extents ... if I can access rows in different pages related to a table simultaneously.

    Let SQL 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

    May 19, 2011 at 12:46 pm

    #1327301

  • RE: Transaction Log Woes

    Ninja's_RGR'us (5/19/2011)

    skcadavre (5/19/2011)

    Ninja's_RGR'us (5/19/2011)

    Time to track the guilty party! 😉

    Not too difficult - there are two of us that work on the database servers and it wasn't me. ....

    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

    May 19, 2011 at 11:54 am

    #1327257

Viewing 15 posts - 26,026 through 26,040 (of 49,552 total)