Forum Replies Created

Viewing 15 posts - 11,806 through 11,820 (of 49,552 total)

  • RE: Path to a Database Architect

    kevaburg (9/4/2013)

    I would recommend looking at the traning requirements for the Microsoft Certified Master.

    You mean the certification that no longer exists?

    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

    September 4, 2013 at 5:46 am

    #1647255

  • RE: Path to a Database Architect

    Seconding Grant. Architect of any type requires years of experience, of working in the field and then learning the architecture side of things.

    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

    September 4, 2013 at 5:43 am

    #1647254

  • RE: sql server using more memory issue

    anoop.mig29 (9/4/2013)

    suppose i set max server memory to certain value , enabled lock pages in memory is enabled, now suppose sql server requires memory more then that what i...

    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

    September 4, 2013 at 4:40 am

    #1647238

  • RE: make VARCHAR field longer on a large table

    That's a meta-data only operation. Because varchar is variable-length, nothing in the rows has to change as a result of 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

    September 3, 2013 at 4:30 pm

    #1647163

  • RE: SQL 2008 Mirroring + Mirroring + Log Shipping

    alanspeckman (9/3/2013)

    1. Can I create either a Mirror off of a Mirrored database, or can I create 2 Mirrors off of one principal?

    No and no.

    2. Having 2 instances with mirrored...

    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

    September 3, 2013 at 3:07 pm

    #1647155

  • RE: SQL Server Full to Simple to Full Recovery Model

    Please take a read through this article on how to manage transaction logs - http://www.sqlservercentral.com/articles/Administration/64582/

    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

    September 3, 2013 at 1:11 pm

    #1647129

  • RE: Difference Between Restore And Attach

    Restore you take a database backup and SQL creates a database with database files from that backup

    Attach you just have the database files (no backup) and SQL creates the database...

    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

    September 3, 2013 at 9:56 am

    #1647088

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/3/2013)

    ... but didn't have the 10 years of SQL Server admin work.

    I don't.

    I have about 8 years experience designing, developing and tuning SQL Server. 0...

    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

    September 3, 2013 at 9:15 am

    #1647076

  • RE: sql 2012 dumps

    Abu Dina (9/3/2013)

    ramyours2003 (9/2/2013)

    Can any one send the sql 2012 dumps for getting the certified ?

    Sure, for a small fee 😀

    I do hope you're joking. If not, that'll be two...

    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

    September 3, 2013 at 7:37 am

    #1647034

  • RE: Transaction Log Functionality Question

    Data files are striped. Log files are used sequentially (hence why there is NO performance benefit from multiple log files)

    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

    September 3, 2013 at 6:56 am

    #1647016

  • RE: Are the posted questions getting worse?

    Having fun preaching there Chris? :hehe:

    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

    September 3, 2013 at 6:38 am

    #1647007

  • RE: Please help on these error messages

    Unrelated to the errors, but be very careful using a table variable. The performance impact is often not acceptable.

    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

    September 3, 2013 at 6:17 am

    #1646993

  • RE: Updating using # table

    Why? What's the purpose of the temp table and how does it get populated?

    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

    September 3, 2013 at 3:32 am

    #1646932

  • RE: Primary Key and Clustered Index: how to set in this example?

    I'd add an artificial primary key and put a unique constraint on the unique set of 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

    September 3, 2013 at 3:16 am

    #1646924

  • RE: intermittment slow data modification on sql 2008 r2

    djordan 4543 (9/3/2013)

    Would it show synchronizing if the database where out of sync for more than 10 seconds because sometimes my proc can run for more than 15 seconds.

    Unlikely. Synchronous...

    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

    September 3, 2013 at 2:41 am

    #1646910

Viewing 15 posts - 11,806 through 11,820 (of 49,552 total)