Forum Replies Created

Viewing 15 posts - 15,031 through 15,045 (of 49,552 total)

  • RE: Report Processing time too long at 7 mins

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    P.S. The filter you have in the HAVING should be in the WHERE clause. Having is for filters on...

    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

    December 31, 2012 at 7:26 am

    #1572506

  • RE: New in this world.. no experience and no knowledge

    Bhuvnesh (12/31/2012)

    Koen Verbeeck (12/31/2012)

    If your boss wants you to learn SQL Server, he should provide you with the proper training. Or at least cover all your expenses.

    It should be but...

    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

    December 31, 2012 at 5:52 am

    #1572494

  • RE: Record locking

    Everything I've said stands. You are looking at a huge amount of development and testing and probably a tonne of bugs and irritations. This isn't a 5 minute job.

    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

    December 31, 2012 at 5:35 am

    #1572491

  • RE: Record locking

    john 60195 (12/31/2012)

    I appreciate the fact that it would be easy to mess up. If a user needs to work on a specific record for a few minutes and during...

    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

    December 31, 2012 at 3:04 am

    #1572464

  • RE: Record locking

    For that you'd need to manually reimplement SQL's locking mechanism, probably with a locking table, manual checks, manual notifications in all code that you have. You then need to consider...

    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

    December 31, 2012 at 1:54 am

    #1572447

  • RE: Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    You don't need it and frankly you probably shouldn't be using readuncommitted without a very good reason.

    See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    (nolock is much the same as read uncommitted, just one's a hint)

    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

    December 31, 2012 at 1:52 am

    #1572446

  • RE: Log File Size Issue

    Figure out what's preventing the log from being reused (there's either some actual replication or CDC that's not working) and fix 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

    December 31, 2012 at 1:49 am

    #1572445

  • RE: Fragmentation size

    zi (12/30/2012)

    Do you have a script to know the fragmentation size for the whole database not only table by table.

    That's a completely nonsensical request as the concept of 'fragmentation size...

    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

    December 30, 2012 at 12:28 pm

    #1572409

  • RE: Simple SQL Query

    burgergetsbored (12/30/2012)

    I managed to get it working now by adding a ORDER BY count DESC LIMIT 1 to the end to return only the highest value. If there's a better...

    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

    December 30, 2012 at 8:39 am

    #1572398

  • RE: Analyst seeking wisdoms while learning the platform

    vega805 (12/29/2012)

    Pluralsight is a Lynda.com for developers, has been a solid segment of my regiment. I believe it is the creation of Pinal Dave.

    Pluralsight was started by Aaron Skonnard,...

    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

    December 30, 2012 at 2:41 am

    #1572389

  • RE: Why Allow Heaps at All?

    Jeff Moden (12/29/2012)

    GilaMonster (12/29/2012)

    You may be interested to know that SQL Azure (or whatever it's called this week), does not allow heaps.

    Understood. Found that out in the very early...

    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

    December 29, 2012 at 12:47 pm

    #1572356

  • RE: Why the table can only have one clustered index?

    Yggaz (12/29/2012)

    Gail, this is just the question. I know how the things are - I do not understand why. The table only exists once - why is it so? We...

    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

    December 29, 2012 at 12:46 pm

    #1572355

  • RE: Why Allow Heaps at All?

    opc.three (12/29/2012)

    I am under the impression that the clustered index requirement is a function of the way the Azure database team decided to replicate data behind the scenes to accomplish...

    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

    December 29, 2012 at 9:04 am

    #1572332

  • RE: Help, my database is corrupt. Now what?

    michael merrill (12/28/2012)

    The idea that the table was actually corrupted (not by a user- but say a disk array error) and it still allowed inserts is the paranoid DBA in...

    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

    December 29, 2012 at 2:20 am

    #1572310

  • RE: Why the table can only have one clustered index?

    Because the table only exists once. The clustered index, as you note, is the table. Yes, you can create secondary indexes with all the columns if you want, they're 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

    December 29, 2012 at 2:15 am

    #1572309

Viewing 15 posts - 15,031 through 15,045 (of 49,552 total)