Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 8,416 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/9/2012)

    Try changing your screen name. Maybe that'll work. @=)

    Am I winning yet?

    January 9, 2012 at 10:12 am

    #1430651

  • RE: Are the posted questions getting worse?

    GSquared (1/9/2012)

    SQL Kiwi (1/9/2012)

    I use spaces in my constraint and index names 😛

    And spell out table names as grammatically correct sentences, including punctuation?

    No, that would be silly 😛

    January 9, 2012 at 10:06 am

    #1430646

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/9/2012)

    Jack's first and last name will always outrank Paul's first and last name, so the only way Paul can get ahead in the SSC leaderboard is to outsmart...

    January 9, 2012 at 10:05 am

    #1430645

  • RE: Are the posted questions getting worse?

    I use spaces in my constraint and index names 😛

    January 9, 2012 at 9:52 am

    #1430626

  • RE: [Column] LIKE 'VALUE%' indexing?!

    aurato (1/9/2012)

    I probably don't need Unicode. But I have a boss who insists upon it. One day it might be useful, who knows. The other suggestions are...

    January 9, 2012 at 9:43 am

    #1430616

  • RE: Are the posted questions getting worse?

    There is a points target I'm keeping an eye on:

    January 9, 2012 at 9:37 am

    #1430609

  • RE: [Column] LIKE 'VALUE%' indexing?!

    aurato (1/9/2012)

    This post cleared up basically all of my remaining confusion. Thank you very much.

    You're welcome.

    aurato (1/9/2012)

    The LIKE query without the '-' works fine. Thanks again. I'm...

    January 9, 2012 at 9:29 am

    #1430597

  • RE: HHMMSS int field to human-friendly time?

    Michael Valentine Jones (1/9/2012)

    I simplified my original code to eliminate three DATEADD function calls and one NULLIF function call, so it might run a bit faster.

    It seems a little slower...

    January 9, 2012 at 9:22 am

    #1430584

  • RE: Exact and Approximate

    L' Eomot Inversé (1/9/2012)

    SQL Kiwi (1/5/2012)

    IIRC that's the same implementation used by the .NET framework. It would make a good Connect suggestion anyway. If you do enter one,...

    January 9, 2012 at 9:07 am

    #1430568

  • RE: [Column] LIKE 'VALUE%' indexing?!

    aurato (1/9/2012)

    Also the UNION ALL took roughly the same amount of time regardless. It's very confusing.

    It's a shame Azure does not support full-text indexing yet. Question: do you...

    January 9, 2012 at 9:05 am

    #1430562

  • RE: [Column] LIKE 'VALUE%' indexing?!

    GilaMonster (1/9/2012)

    While that's listed as a seek (for the like), it's almost a full table scan. The predicate is Keyword > '-', which every single entry starting with A..Z, a..z,...

    January 9, 2012 at 8:55 am

    #1430548

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/9/2012)

    SQL Kiwi (1/5/2012)

    Jack Corbett (1/5/2012)

    Have had a discussion with Aaron Bertrand about case-sensitivity recently.

    You knows he's super-anti-underscores?

    Yes I do. I've had that discussion with him as well....

    January 9, 2012 at 8:06 am

    #1430488

  • RE: Table Valued Functions and Repeatable Reads

    The short answer is no, neither of your two examples are guaranteed to read the same value at the default read committed isolation level, unless the database option READ_COMMITTED_SNAPSHOT is...

    January 9, 2012 at 8:04 am

    #1430486

  • RE: date & time extraction

    Delario (1/9/2012)

    select to_char(<my column name>, 'mm') from <my table name>

    That looks like Oracle syntax! The SQL Server functions are as Cadavre demonstrates, but just as a curiosity, I understand...

    January 9, 2012 at 7:33 am

    #1430456

  • RE: HHMMSS int field to human-friendly time?

    And, just to complete the picture, here's a CLR scalar function (not in-line!):

    CREATE ASSEMBLY [DateTimeExtensions]

    AUTHORIZATION [dbo]

    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030024F30A4F0000000000000000E00002210B010800000A000000060000000000009E280000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000442800005700000000400000C803000000000000000000000000000000000000006000000C0000008C2700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000A408000000200000000A000000020000000000000000000000000000200000602E72737263000000C80300000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C00000000600000000200000010000000000000000000000000000040000042000000000000000000000000000000008028000000000000480000000200050094200000F80600000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133007002F00000001000011000220102700005B021F645B1F645D021F645D0320102700005B031F645B1F645D031F645D730F00000A0A2B00062A1E02281000000A2A0042534A4201000100000000000C00000076322E302E35303732370000000005006C000000E0010000237E00004C0200009402000023537472696E677300000000E00400000800000023555300E8040000100000002347554944000000F80400000002000023426C6F620000000000000002000001471502000900000000FA2533001600000100000011000000020000000200000002000000100000000C00000001000000010000000200000000000A00010000000000060046003F0006004D003F00060091007F000600A8007F000600C5007F000600E4007F000600FD007F00060016017F00060031017F0006004C017F00060084016501060098017F000600C401B1013700D801000006000702E70106002702E7010A007F02640200000000010000000000010001000100100021000000050001000100502000000000960056000A0001008B200000000086186F0011000300000001007500000002007A0019006F00150021006F00150029006F00150031006F00150039006F00150041006F00150049006F00150051006F00150059006F001A0061006F00150069006F001F0079006F00250081006F00110089006F00110011006F00720109006F001100200073002A002E002B0081012E00130099012E001B0099012E0023009F012E000B0081012E003300AE012E003B0099012E004B0099012E005B00CF012E006300D8012E006B00E1017C01048000000100000028113A15000000000000450200000200000000000000000000000100360000000000020000000000000000000000010058020000000000000000003C4D6F64756C653E004461746554696D65457874656E73696F6E732E646C6C0055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D004F626A656374004461746554696D65004461746554696D6546726F6D496E74656765725061727473002E63746F7200446174650054696D650053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465004461746554696D65457874656E73696F6E730053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E4174747269627574650000032000000000002D4C33179D0E4D4BAAE00759A4F1A8860008B77A5C561934E0890600021109080803200001042001010E042001010205200101113904200101088146010004005455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A446174614163636573730000000054020F497344657465726D696E6973746963015402094973507265636973650154557F4D6963726F736F66742E53716C5365727665722E5365727665722E53797374656D446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038391053797374656D4461746141636365737300000000092006010808080808080407011109170100124461746554696D65457874656E73696F6E7300000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313200000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000024F30A4F000000000200000099000000A8270000A80900005253445336FDC6FA984ACC49ACCF9F555F663F9403000000633A5C75736572735C7061756C2077686974655C646F63756D656E74735C76697375616C2073747564696F20323031305C50726F6A656374735C4461746554696D65457874656E73696F6E735C4461746554696D65457874656E73696F6E735C6F626A5C44656275675C4461746554696D65457874656E73696F6E732E706462000000006C28000000000000000000008E280000002000000000000000000000000000000000000000000000802800000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000006C03000000000000000000006C0334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001003A152811000001003A1528113F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004CC020000010053007400720069006E006700460069006C00650049006E0066006F000000A8020000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500013000100460069006C0065004400650073006300720069007000740069006F006E00000000004400610074006500540069006D00650045007800740065006E00730069006F006E007300000000003C000E000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003300390032002E003500340033003400000050001700010049006E007400650072006E0061006C004E0061006D00650000004400610074006500540069006D00650045007800740065006E00730069006F006E0073002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F006600740020003200300031003200000000005800170001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004400610074006500540069006D00650045007800740065006E00730069006F006E0073002E0064006C006C0000000000480013000100500072006F0064007500630074004E0061006D006500000000004400610074006500540069006D00650045007800740065006E00730069006F006E0073000000000040000E000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003300390032002E003500340033003400000044000E00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003300390032002E0035003400330034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000A03800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

    WITH PERMISSION_SET = SAFE

    GO

    CREATE FUNCTION dbo.DateTimeFromIntegerParts

    (

    @Date integer,

    ...

    January 9, 2012 at 7:08 am

    #1430440

Viewing 15 posts - 1,291 through 1,305 (of 8,416 total)