Forum Replies Created

Viewing 15 posts - 8,206 through 8,220 (of 49,552 total)

  • RE: Index creation

    What does "Creating an index within the application" even mean?

    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

    August 7, 2014 at 1:12 pm

    #1736159

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/7/2014)

    Put them in the same boat as WC.

    Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you...

    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

    August 7, 2014 at 1:04 pm

    #1736153

  • RE: Table Partitioning Question

    alex_pixley (8/7/2014)

    Yes, adding disk space is easy. In some environments, however, getting additional disk space approved and implemented is a painful process. Right now, I have 13 partitions...

    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

    August 7, 2014 at 1:01 pm

    #1736151

  • RE: TDE (SQL2008R2) in a production environment?

    SQLRNNR (8/7/2014)

    I think the bigger issue is really that the fragmentation becomes a lot more noticeable because of the little bit of a hit that is caused by TDE.

    And fragmentation...

    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

    August 7, 2014 at 12:54 pm

    #1736149

  • RE: INSERT Table into ITSELF???? WHY???

    Maxer (8/7/2014)

    I was wondering about odd scenarios with dirty read for that select or if it could ever fail to read 100% of the rows up front so it attempts...

    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

    August 7, 2014 at 10:56 am

    #1736099

  • RE: SELECT clause

    ScottPletcher (8/7/2014)

    Which is why I don't quite understand the "definitely not!" 🙂

    You may have missed the word before that phrase.

    "The average of those isn't 'definitely not'"

    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

    August 7, 2014 at 9:34 am

    #1736050

  • RE: Different result for one query

    Virendra Yaduvanshi (8/7/2014)

    query is used with nolock

    Then start by removing nolock, as it causes exactly this (duplicated rows). Same with read uncommitted isolation level.

    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

    August 7, 2014 at 9:31 am

    #1736048

  • RE: Different result for one query

    Is it repeatable

    Are they connecting to the same instance, same database

    Are they using nolock/read uncommitted?

    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

    August 7, 2014 at 7:35 am

    #1735961

  • RE: INSERT Table into ITSELF???? WHY???

    Maxer (8/6/2014)

    1. It just doubles all rows in the table.

    Yes

    2. Would it ever NOT do that? Would you ever get a batch scenario where you read maybe...

    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

    August 7, 2014 at 4:42 am

    #1735905

  • RE: Deadlock during insert activity

    Can you post the definition of the procedure SCHOrdersSave_v3?

    Also, where's the rest of the deadlock graph? The resources section is missing, please post 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

    August 7, 2014 at 2:36 am

    #1735871

  • RE: SQL DBA high ended question (5+ years’ experience)

    jonidotcodotuk (8/7/2014)

    Jeff Moden (8/6/2014)

    Ed Wagner (8/6/2014)

    How about a very simple one?

    Please write the T-SQL code to count from 1 to 10.

    There are many correct answers and how they answer can...

    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

    August 7, 2014 at 2:34 am

    #1735869

  • RE: Table Partitioning Question

    An empty partition is not going to be taking up any space.

    Or do you mean swap out and merge old partitions as time goes on? If so, that's just...

    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

    August 7, 2014 at 12:43 am

    #1735847

  • RE: Can't Drop Table, Select or create a PK or Index

    David Webb-CDS (8/6/2014)

    Blocking on the system tables would be my first guess. Did you check for blocking locks?

    Not on the system tables. On the table itself. Dropping, altering, creating...

    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

    August 6, 2014 at 4:19 pm

    #1735805

  • RE: Can't Drop Table, Select or create a PK or Index

    Your query is blocked. Check and see what is blocking you.

    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

    August 6, 2014 at 4:16 pm

    #1735802

  • RE: SQL DBA high ended question (5+ years’ experience)

    Luis Cazares (8/6/2014)

    Eirikur Eiriksson (8/6/2014)

    benjamin.reyes (8/6/2014)

    Eirikur Eiriksson (8/5/2014)

    Grant Fritchey (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what...

    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

    August 6, 2014 at 3:36 pm

    #1735796

Viewing 15 posts - 8,206 through 8,220 (of 49,552 total)