Forum Replies Created

Viewing 15 posts - 18,616 through 18,630 (of 49,552 total)

  • RE: An examination of bulk-logged recovery model

    matt.bowler (5/7/2012)

    I do have one question: in the final demo where you looked at the log usage for an index rebuild, you mentioned "log reservation in case of rollback". 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

    May 8, 2012 at 5:47 am

    #1484441

  • RE: Query blocking

    Chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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 8, 2012 at 4:46 am

    #1484423

  • RE: Just a Quick Question

    Bhuvnesh (5/8/2012)

    I am totally agree with you but take it in other way around, database/schema designs are not done on current requirements/structures only but also keeping future in mind...

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

    #1484364

  • RE: Referential Integrity: Who needs it - right? (Discussion)

    Jeff Moden (5/7/2012)

    Let's put it this way, Gail. If you're one of the folks that thinks there's something seriously wrong with allowing front end developers to "design" tables using...

    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 8, 2012 at 2:22 am

    #1484362

  • RE: upgrade from SQL 2008 R2 to SQL 2012

    george sibbald (5/7/2012)

    mirroring requires both partners to be the same version of SQL so this will not work.

    It will work, it is a documented way of doing a rolling 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

    May 7, 2012 at 5:22 pm

    #1484280

  • RE: Are the posted questions getting worse?

    Revenant (5/7/2012)

    GilaMonster (5/7/2012)

    Revenant (5/7/2012)

    Jan Van der Eecken (5/7/2012)

    Would certainly be great fun writing writing a CLR UDF in C. Maybe with a bit of embedded ASM inside? I'm sure 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

    May 7, 2012 at 4:15 pm

    #1484270

  • RE: Are the posted questions getting worse?

    Revenant (5/7/2012)

    Jan Van der Eecken (5/7/2012)

    Would certainly be great fun writing writing a CLR UDF in C. Maybe with a bit of embedded ASM inside? I'm sure it can be...

    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 7, 2012 at 3:31 pm

    #1484255

  • RE: Referential Integrity: Who needs it - right? (Discussion)

    Jeff Moden (5/5/2012)

    I think that people who insist that the application can take care of RI are just about as flambouyantly in desregard (and equally wrong) for proper database design...

    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 7, 2012 at 1:24 pm

    #1484195

  • RE: Just a Quick Question

    .Netter (5/7/2012)

    Its not in the company standard its my line manger which has said its the number 1 rule every SQL person follows, which i did find hard to believe...

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

    #1484138

  • RE: data file migration..

    Why don't you test it out and see? That's a very easy thing to try out on a local instance of SQL and you'll learn far more from trying 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

    May 7, 2012 at 9:22 am

    #1484102

  • RE: data file migration..

    Question doesn't make sense.

    Data files don't 'replicate', databases do and only if there's something set up to copy the database to another 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

    May 7, 2012 at 9:03 am

    #1484093

  • RE: Resource Governor

    You need to create a classifier function that classifies that login (based on any attribute of the login) and returns the workload group name. Then you need to alter resource...

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

    #1484056

  • RE: How to get a list of database objects changed between specific time sql server

    Query your source control system. You do put database objects into source control...?

    p.s. Please post new questions in a new 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

    May 7, 2012 at 5:39 am

    #1484038

  • RE: Just a Quick Question

    The only requirement for creating a table within SQL Server is that the table must have at least one column.

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

    #1484037

  • RE: sysadmin role not recognized by some databases

    Are you absolutely sure that you are logging in as the account that is sysadmin? Are you absolutely sure that it did get added to the sysadmin role?

    Double check...

    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 6, 2012 at 12:32 pm

    #1483914

Viewing 15 posts - 18,616 through 18,630 (of 49,552 total)