Forum Replies Created

Viewing 15 posts - 271 through 285 (of 355 total)

  • RE: Column Order in an Index

    David Walker-278941 (11/23/2010)

    If you change the columns to Char(8) now, there won't ever be 450 characters in the column!

    If the vendor sending the data says that the data...

    November 23, 2010 at 11:32 am

    #1254646

  • RE: Column Order in an Index

    Doh, I just discovered the maximum key length is 900 bytes so combining two VARCHAR(500) columns into one index results in a warning:

    The maximum key length is 900 bytes. ...

    November 23, 2010 at 10:52 am

    #1254608

  • RE: Column Order in an Index

    GilaMonster (11/23/2010)

    cengland0 (11/23/2010)

    Wilfred van Dijk (11/23/2010)

    aha, the never-ending question about multicolumn or single column indexes!

    Again, check Gail's excellent articles about indexes:

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    Thanks for the link but I get "404 - File...

    November 23, 2010 at 10:31 am

    #1254593

  • RE: Column Order in an Index

    Michael Ebaya (11/23/2010)

    cengland0 (11/23/2010)

    Please don't laugh at me for asking this question.

    Why would you create a compound index with both last name and first name together? Why not two...

    November 23, 2010 at 10:24 am

    #1254588

  • RE: Column Order in an Index

    Wilfred van Dijk (11/23/2010)

    aha, the never-ending question about multicolumn or single column indexes!

    Again, check Gail's excellent articles about indexes:

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/%5B/url%5D

    Thanks for the link but I get "404 - File...

    November 23, 2010 at 7:38 am

    #1254459

  • RE: T-SQL GO statement

    Excellent question. Finally one without any trick and one where I actually learned something. I can actually find a use for this feature.

    November 23, 2010 at 6:49 am

    #1254415

  • RE: Column Order in an Index

    Please don't laugh at me for asking this question.

    Why would you create a compound index with both last name and first name together? Why not two separate indexes where...

    November 23, 2010 at 6:44 am

    #1254412

  • RE: Conditional Order By

    mister.magoo (11/16/2010)

    Thanks to those of you who appreciate this question.

    To those who think it had unnecessary "tricks" in it, I did try several variants of this question and they all...

    November 17, 2010 at 3:45 am

    #1251782

  • RE: Query text during caching in SQL 2005

    Any BOL links you can provide regarding this? There wasn't one in the explanation.

    November 15, 2010 at 5:40 am

    #1250641

  • RE: Database Snapshot

    janki_2886 (11/9/2010)

    This was Question Direct from BOL, I have used same sentence as in BOL, Do you still think, its a grammer mistake.

    Not saying it's a grammar mistake. I'm...

    November 9, 2010 at 9:42 am

    #1248390

  • RE: Database Snapshot

    steve block (11/9/2010)

    I too chose None of the Above (interpreting that it meant ("it depends") because system databases are excluded from Database Snapshots. If you follow the logic that...

    November 9, 2010 at 7:32 am

    #1248286

  • RE: Database Snapshot

    Hugo Kornelis (11/9/2010)

    Nice, easy question.

    I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually...

    November 9, 2010 at 3:25 am

    #1248112

  • RE: COLLATION

    Michael Poppers (11/3/2010)

    Yes, he might have been better off listing the possible choice as SELECT CONVERT(char, SERVERPROPERTY('collation','MyDatabaseName')) and perhaps that was his intention :-).

    Agreed. I work in a training...

    November 3, 2010 at 9:50 am

    #1246120

  • RE: COLLATION

    SanDroid (11/3/2010)

    Nice question.

    I learned something, there were no errors or typos with the answer, and the reference data supported the documentation.

    The only negative comment I have is that...

    November 3, 2010 at 7:10 am

    #1245964

  • RE: COLLATION

    Curious why it was being converted to Char in the query.

    November 3, 2010 at 2:44 am

    #1245877

Viewing 15 posts - 271 through 285 (of 355 total)