Forum Replies Created

Viewing 15 posts - 76 through 90 (of 607 total)

  • Reply To: Are the posted questions getting worse?

    stupid question time. when you guys deal with X12 spec files, is there a reasonable argument *against* loading them into tables named for loops/segments/ref numbers?

    I get that they are variable...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Representing uncertainty in difficult times

    Dearest Philip,

    You seem to be asking "How do we force people to be critical thinkers"? Folks who already are, will question if any bias exists, look at multiple sources, dig...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: May the Force Be With You

    Enjoyed the last trilogy (episodes 7-9), but they weren't ground-breaking, just kinda fun and nostalgic. The way they are constantly trying to "rescue the damsel" and she's always three steps...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Selecting data between just month and year

    Honestly, just give them a datepicker and let them pick it that way. Users need to have some small responsibility here.

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Object naming

     

    While your assumption of my incompetence probably would save you time somewhere, no, I do not fall in that group of people. Also, bite me.

    Just because there are ways to...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Object naming

    Mr. Brian Gale wrote:

    You could use "location" still, but put []'s around it too.  My habit is to put [] around my objects.  Never know when a new version of SQL will...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Object naming

    I prefer to name my address tables "whereDeyAt", my individual identifier table "whoDey" and the transaction table showing activities "whazzzaaaaaaaap" (I alias that one, it's long)

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Keeping Unique Aliases

    I always write code as if the next maintainer of the code is a psychopath with my home address

    Life lesson, that. Sometimes it is. When I write it and then...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Are the posted questions getting worse?

    I usually get speeches like this - "we usually would have SoAndSo work on that, but he's on vacation for a month. But don't worry, we have a new resource...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Conversion failed when converting the varchar value ' ' to data type int

    well, if you're trying to update the samplecolumn field, you don't list that in your update, you're updating the type_of_column (maybe a problem in your sample data?)

    Other than that, are...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Representing XML data in SQL Server

    Aaron N. Cutshall wrote:

    Jeff's experience not withstanding, I've actually had good experiences with XML. But then, I was the one who established the format and oversaw its implementation and use. I have...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Expand/Collapse action shows "+" instead of "-"

    try swapping your true and false values in the iif()

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Nested Views and General ETL Design Advie

    I'm not following the benefit of the synonyms for the tables and the first layer of views, you're doing that JUST to re-order the columns?

    As for the direct query vs...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: Server Side SSMS

    I don't fully understand why we don't all do *everything* on a remote box, and basically just use local hardware as a viewing window into remote systems. Seems much more...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Reply To: The Conferences of the Future

    Brent Ozar wrote:

    Doctor Who 2 wrote:

    They are using Azure, and we were just beginning to look into Azure. I had a chance to talk with them, learn what they had learned and so...

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Viewing 15 posts - 76 through 90 (of 607 total)