Forum Replies Created

Viewing 15 posts - 19,741 through 19,755 (of 49,552 total)

  • RE: Index Fragmentation

    derekr 43208 (3/15/2012)

    Considering that a clustered index is the actual table, does that mean that if it's fragmented, the actual data is not in order of the clustering key.

    For the...

    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

    March 15, 2012 at 7:29 am

    #1459830

  • RE: Missing key

    Koen Verbeeck (3/15/2012)

    It seems there are 2 correct answers :w00t:

    No, there's only one that will both work and do what the question requires.

    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

    March 15, 2012 at 6:34 am

    #1459783

  • RE: Using IF EXISTS & NOT EXISTS DROP Primary Key Constraint

    Then filter on the schema_id in sys.key_constraints as well as the name.

    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

    March 15, 2012 at 6:26 am

    #1459776

  • RE: TempDB configuration on VM

    http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

    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

    March 15, 2012 at 6:24 am

    #1459772

  • RE: Missing key

    Homework?

    What do you think it is and why? hit: read up on identity columns and identity insert in SQL Books Online

    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

    March 15, 2012 at 6:20 am

    #1459767

  • RE: Primary key and clustering key - are they the same thing?

    Eugene Elutin (3/15/2012)

    There are no such thing as "CLUSTERING KEY" in SQL Server as such, but CLUSTERED INDEX.

    The term 'clustering key' refers to the key column(s) of the clustered...

    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

    March 15, 2012 at 6:06 am

    #1459759

  • RE: Finding time between 2 dates considering working hours

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    March 15, 2012 at 4:37 am

    #1459722

  • RE: Finding time between 2 dates considering working hours

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1267335-392-1.aspx

    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

    March 15, 2012 at 4:37 am

    #1459721

  • RE: Index Fragmentation

    derekr 43208 (3/15/2012)

    Am I right in that when an Index is fragmented, its pages are out of order?

    This means that more I/O operations are required to fetch whatever it needs?

    Pretty...

    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

    March 15, 2012 at 4:26 am

    #1459713

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/14/2012)

    This?

    http://www.amazon.com/Star-Wars-Omnibus-Tales-Jedi/dp/1593078307

    and this: http://www.amazon.com/Star-Wars-Omnibus-Tales-Jedi/dp/1593079117/ref=pd_sim_b_5

    Those are way cheaper than last time I saw them. Time to buy maybe...

    Here's the first of the Darth Bane books: http://www.amazon.com/Path-Destruction-Star-Wars-Darth/dp/0345477375/ref=pd_sim_b_9

    Edit: And...

    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

    March 14, 2012 at 5:16 pm

    #1459562

  • RE: Is this a bug?

    It's not a bug, in that it is expected and documented behaviour. A bug would be where SQL does something other than what it is supposed to do.

    Could it cause...

    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

    March 14, 2012 at 4:55 pm

    #1459557

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/14/2012)

    GilaMonster (3/14/2012)

    It was part of a whole re-organisation of both the Republic and the Jedi Order after the New Sith Wars, the Republic Dark Age,...

    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

    March 14, 2012 at 4:40 pm

    #1459551

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (3/14/2012)

    GilaMonster (3/14/2012)

    sp_OA* (for those who find CLR too safe)

    Some things just never go away. That dates from 6.5, doesn't it?

    No idea, my usage of SQL started...

    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

    March 14, 2012 at 4:21 pm

    #1459546

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/14/2012)

    I'm sorry, I have to ask. If they could have attachments for the first 24,000 years why did this one Jedi Master decide it was bad? ...

    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

    March 14, 2012 at 4:19 pm

    #1459544

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/14/2012)

    Gianluca Sartori (3/14/2012)

    Back on topic, yes, they definitely are: http://www.sqlservercentral.com/Forums/FindPost1266924.aspx

    I actually laughed out loud.

    Well it's one of our old friends, so are you that surprised?

    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

    March 14, 2012 at 2:57 pm

    #1459508

Viewing 15 posts - 19,741 through 19,755 (of 49,552 total)