Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,241 total)

  • RE: Does anyone know what this verbage means ?

    If you right click a column in a table, and choose properties >

    you will see a node for 'Extended Properties.' Here you define what you want to add to...

    January 4, 2016 at 6:20 pm

    #1849422

  • RE: Best way to merge two large client databases

    Aside from the task of somehow accounting for the same client across the two databases potentially, a thought I have is that in theory you can load the ids for...

    January 4, 2016 at 4:39 pm

    #1849411

  • RE: CLR Yes or no?

    Solomon Rutzky (12/29/2015)

    Eric M Russell (12/26/2015)

    Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in...

    January 4, 2016 at 4:06 pm

    #1849407

  • RE: Dynamic Query issue

    Re1 (12/29/2015)

    Thanks Luis it works fine

    Hi, did you make use of the "DelimitedSplit8K" function?

    January 4, 2016 at 3:34 pm

    #1849395

  • RE: Number VS Letter

    My first impression when I see these restrictions is, if this is a test or homework question for a class.

    December 30, 2015 at 3:45 pm

    #1848863

  • RE: The Most Common Query Blunders...

    Jeff Moden (12/25/2015)

    I believe my favorite non-SARGable problems are due to the inappropriate use of "OR" and things like the following...

    WHERE ISNULL(SomeNumericColumn,0) > 0

    ...

    WHERE ISNULL(SomeCharacterColumn,' ')...

    December 30, 2015 at 3:36 pm

    #1848861

  • RE: The Most Common Query Blunders...

    Jeff Moden (12/28/2015)

    Alan.B (12/28/2015)

    Someone beat me to it but NOLOCK table hints are the #1 mistake I have seen.

    Heh... apparently, thousands of people agree with you. Instead, they...

    December 30, 2015 at 3:29 pm

    #1848860

  • RE: Best way to merge two large client databases

    Eric M Russell (12/30/2015)

    Orlando Colamatteo (12/30/2015)

    Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment...

    December 30, 2015 at 3:06 pm

    #1848856

  • RE: Where Do Staging Tables Belong

    As the name implies, staging is just that. The data is not meant to be a permanent fixture, otherwise call it a operation data store. If the goal is auditing...

    December 30, 2015 at 2:12 pm

    #1848841

  • RE: Altering Included Indexes

    SQL-DBA-01 (12/30/2015)

    Soemthing is wrong here in the question. I guess the choice should be "only 1".

    orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

    +1

    I avoided...

    December 30, 2015 at 1:49 pm

    #1848836

  • RE: Aircaft latitude and longitude points

    This looks like more of a math problem. You need to be able to define the function that represents the curve of travel. I am sure once you have that...

    December 18, 2015 at 10:56 am

    #1846844

  • RE: Insert records that do not exist

    Michael L John (12/17/2015)

    GilaMonster (12/17/2015)

    MMartin1 (12/17/2015)

    Does the SELECT 1 provide a big performance gain or just prevents a call to the disk that may get delayed?

    Neither. It's there to...

    December 17, 2015 at 4:51 pm

    #1846681

  • RE: Splitting measures in a Fact Table

    It appears from my understanding that this could very well be quite complex maintenance wise. In your design, could you not snowflake out the course # to include the...

    December 17, 2015 at 1:18 pm

    #1846654

  • RE: Insert records that do not exist

    GilaMonster (12/15/2015)

    Your exists subquery has no reference to the table in the outer query. Hence it will only be evaluated once and if the subquery returns any rows at all,...

    December 17, 2015 at 12:44 pm

    #1846648

  • RE: Insert records that do not exist

    shank-130731 (12/15/2015)

    This worked for me, sort of. UAO.InvNo had a few records that were duped which stopped the query. When I deleted the dupes the query ran as expected. Thanks!

    INSERT...

    December 17, 2015 at 12:42 pm

    #1846647

Viewing 15 posts - 661 through 675 (of 1,241 total)