Forum Replies Created

Viewing 15 posts - 13,426 through 13,440 (of 49,552 total)

  • RE: Asking for Interview Questions

    pdanes (4/18/2013)

    GilaMonster (4/18/2013)

    Eric M Russell (4/18/2013)

    Also, tell the candidate up front that all new hires are required to sign an "employment at-will" contract. If they don't measure up, then they'll...

    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 18, 2013 at 11:42 am

    #1607925

  • RE: Asking for Interview Questions

    Eric M Russell (4/18/2013)

    Also, tell the candidate up front that all new hires are required to sign an "employment at-will" contract. If they don't measure up, then they'll just get...

    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 18, 2013 at 11:27 am

    #1607914

  • RE: full and differential backup

    Then...

    GilaMonster (4/18/2013)

    If you're getting that error when backing up, then the database you're trying to back up is not accessible. Don't try things like taking it offline/online without looking at...

    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 18, 2013 at 11:12 am

    #1607905

  • RE: DBCC CheckDB - Snapshot

    curious_sqldba (4/18/2013)

    Paul Randal (4/18/2013)

    It used to take table locks in 7.0 - from 2000 onwards it's been online by default, with no table locks.

    Thanks Paul. If DBCC doesn't place any...

    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 18, 2013 at 10:57 am

    #1607890

  • RE: Plan Reuse - Unrelated tables in execution plan

    In summary, incorrect data. Not dirty reads, missing rows and duplicate rows. You can read entire chunks of data twice (or more). You can miss entire chunks of rows.

    Fine for...

    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 18, 2013 at 10:52 am

    #1607884

  • RE: DBCC CheckDB - Snapshot

    Thanks. Post corrected accordingly (I never worked with SQL 7)

    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 18, 2013 at 10:49 am

    #1607878

  • RE: Stored Procedures Execute Permissions

    Dree Vasquez (4/18/2013)

    I don't think it is correct to grant everyone db_owner privileges.

    No, absolutely not. Principal of minimal privileged. Users don't need to be able to drop the database, delete...

    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 18, 2013 at 8:39 am

    #1607799

  • RE: avoiding duplicates in comma separated values column

    To be bluntly honest, comma-delimited lists are a hint that the table design isn't right. Why a comma-delimited list in a column and not a child table with one row...

    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 18, 2013 at 8:24 am

    #1607788

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/18/2013)

    GilaMonster (4/18/2013)

    Forum points: A measure of how much time is spend not doing productive work.

    Hey! This is productive. (SET @PompousVoice = ON) I'm building my brand and borrowing...

    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 18, 2013 at 8:07 am

    #1607776

  • RE: Plan Reuse - Unrelated tables in execution plan

    Preet_S (4/18/2013)

    The optimiser will NOT use a plan for one query for another query.)

    Agreed, my misunderstanding. Except in the case of Parameter Sniffing.

    No exceptions. Parameter sniffing is the same...

    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 18, 2013 at 8:06 am

    #1607775

  • RE: Are the posted questions getting worse?

    Forum points: A measure of how much time is spend not doing productive work.

    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 18, 2013 at 7:39 am

    #1607752

  • RE: partitioning strategy for this scenario:

    Yes.

    With the automated one, creating partitions happens and you'll never run out of partitions (unless the job fails) and you keep to a minimum the number of partitions that SQL...

    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 18, 2013 at 7:33 am

    #1607741

  • RE: partitioning strategy for this scenario:

    Cool. Just bear in mind that performance gains are not automatic.

    I'd suggest option 1. You don't have to (and in fact shouldn't) do the split/merge manually, have a job 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

    April 18, 2013 at 7:07 am

    #1607716

  • RE: partitioning strategy for this scenario:

    What's the goal here? Why are you considering partitioning?

    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 18, 2013 at 6:55 am

    #1607712

  • RE: Indexes with JOINs

    The Comedian (4/18/2013)

    CREATE NONCLUSTERED INDEX INDEX_Q1_Employee ON Employee(

    EmploymentStatus ASC,

    LastName ASC,

    FirstName ASC)

    INCLUDE (Company, Department)

    CREATE NONCLUSTERED INDEX INDEX_Q1_People ON People(

    Profession ASC,

    LastName ASC,

    FirstName ASC)

    INCLUDE (Age, Address)

    Yes, those are much better and they'll work...

    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 18, 2013 at 6:34 am

    #1607696

Viewing 15 posts - 13,426 through 13,440 (of 49,552 total)