Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Ok, so it sort of is about SQL....


Ok, so it sort of is about SQL....

Author
Message
mister.magoo
mister.magoo
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2286 Visits: 7830
Sean Lange (4/22/2013)
mister.magoo (4/19/2013)
Sean Lange (4/19/2013)
I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is for but...

There is a column ConstantC char(1).

Anyone want to take a guess what value you will find in all 1.2 million rows???

Not only do we have 1.2 million copies of the same value, just using the column is 9 or 10 extra keystrokes than just using the actual constant from the keyboard. w00t


Please tell me there is an index on it as well!


No the table is a heap!!! I have been asking around and nobody knows what the table is even used for. :-P


Oh, that's a shame, an index on 1.2 million repetitions of "C" would have been sooooo nice :-P

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Sean Lange
    Sean Lange
    SSCoach
    SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

    Group: General Forum Members
    Points: 16667 Visits: 17030
    mister.magoo (4/22/2013)
    Sean Lange (4/22/2013)
    mister.magoo (4/19/2013)
    Sean Lange (4/19/2013)
    I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is for but...

    There is a column ConstantC char(1).

    Anyone want to take a guess what value you will find in all 1.2 million rows???

    Not only do we have 1.2 million copies of the same value, just using the column is 9 or 10 extra keystrokes than just using the actual constant from the keyboard. w00t


    Please tell me there is an index on it as well!


    No the table is a heap!!! I have been asking around and nobody knows what the table is even used for. :-P


    Maybe I will add a clustered index.

    Oh, that's a shame, an index on 1.2 million repetitions of "C" would have been sooooo nice :-P


    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Moden's splitter.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
    Understanding and Using APPLY (Part 1)
    Understanding and Using APPLY (Part 2)
    SQLRNNR
    SQLRNNR
    SSC-Insane
    SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

    Group: General Forum Members
    Points: 21133 Visits: 18259
    Sean Lange (4/22/2013)
    mister.magoo (4/22/2013)
    Sean Lange (4/22/2013)
    mister.magoo (4/19/2013)
    Sean Lange (4/19/2013)
    I had to dig around a bit to find this one. One of our legacy tables replicated from the Main Frame has a table that nobody really knows it is for but...

    There is a column ConstantC char(1).

    Anyone want to take a guess what value you will find in all 1.2 million rows???

    Not only do we have 1.2 million copies of the same value, just using the column is 9 or 10 extra keystrokes than just using the actual constant from the keyboard. w00t


    Please tell me there is an index on it as well!


    No the table is a heap!!! I have been asking around and nobody knows what the table is even used for. :-P


    Maybe I will add a clustered index.

    Oh, that's a shame, an index on 1.2 million repetitions of "C" would have been sooooo nice :-P


    How about adding a filtered index ;-):-D



    Jason AKA CirqueDeSQLeil
    I have given a name to my pain...
    MCM SQL Server, MVP


    SQL RNNR

    Posting Performance Based Questions - Gail Shaw

    WayneS
    WayneS
    SSCertifiable
    SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

    Group: General Forum Members
    Points: 6261 Visits: 10404
    SQLRNNR (4/19/2013)
    Jeffrey Williams 3188 (4/18/2013)
    But...what if truncate doesn't actually remove everything that was there before? Don't we have to be sure we delete it before we insert? w00t


    Obviously truncate means randomly delete data iif you feel like it.


    Well, that inline if does stuff like that! w00t

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes
    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
    CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search