Forum Replies Created

Viewing 15 posts - 271 through 285 (of 3,061 total)

  • RE: Key Assignment in a Time Dimension Table with Duplicate Entries

    dj1202 (6/15/2012)

    Hello all, I am creating a table, named DimCalendar, which has the following columns:

    DateID (date)

    Quarter

    Year

    Month

    Week

    Day

    InvoiceNumber

    There are duplicate dates in the DateID column, but I would like to assign a...

    June 15, 2012 at 2:15 pm

    #1501886

  • RE: Best Practices querying Oracle data from Sql Server

    chenthor (6/13/2012)

    Thank you for the response! Do you see any advantages/disadvantages of using embedded queries in the reports vs stored procedures on the sql server? I believe that stored procedures...

    June 14, 2012 at 5:09 am

    #1500900

  • RE: Best Practices querying Oracle data from Sql Server

    Anything but four-part naming query would do it. Four-part naming queries have the tendency of moving the whole target tables over the link then apply filtering on the local host...

    June 13, 2012 at 4:15 pm

    #1500717

  • RE: Hash Partitioning

    opc.three (5/19/2012)

    So would you say this is simply one area where the concept does not transfer from Oracle to SQL Server? Oracle touts partitioning as a way to improve performance...

    May 19, 2012 at 3:29 pm

    #1490156

  • RE: sub query

    sandeep4testing (5/19/2012)

    any one call help me with fallowing query

    How to find the name of the employee who manages more employees?

    Do you realize nobody can write your (home work) query...

    May 19, 2012 at 6:57 am

    #1490115

  • RE: Sage/Accpac/PSQL support for MSSQL08

    Manny Cruz (5/18/2012)

    We are looking to replace our accounting package to the above named product. We already have mssql08r2 installed - our porfolio mgmt software runs on top of that.

    In...

    May 18, 2012 at 3:58 pm

    #1489993

  • RE: query works but not in a view

    You have a good point Howard which means Jeff also has it.

    In a real world situation, facing that scenario we could always go back to the function based index Jeff...

    May 16, 2012 at 10:45 am

    #1488556

  • RE: query works but not in a view

    Jeff Moden (5/14/2012)

    PaulB-TheOneAndOnly (5/14/2012)

    Jeff Moden (5/10/2012)

    PaulB-TheOneAndOnly (5/10/2012)

    Jeff Moden (5/9/2012)

    PaulB-TheOneAndOnly (5/9/2012)

    If MSTR_END on WHERE clause is causing the issue replace the condition with:

    where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''

    IIRC, that'll make for a non-SARGable...

    May 16, 2012 at 8:48 am

    #1488454

  • RE: query works but not in a view

    Jeff Moden (5/10/2012)

    PaulB-TheOneAndOnly (5/10/2012)

    Jeff Moden (5/9/2012)

    PaulB-TheOneAndOnly (5/9/2012)

    If MSTR_END on WHERE clause is causing the issue replace the condition with:

    where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''

    IIRC, that'll make for a non-SARGable search predicate just...

    May 14, 2012 at 8:10 am

    #1487134

  • RE: query works but not in a view

    Denise McMillan (5/9/2012)

    I took out mstr_end out of the select portion and it works. I didn't really need to select it, just had it while working on the...

    May 10, 2012 at 2:37 pm

    #1485980

  • RE: query works but not in a view

    Denise McMillan (5/10/2012)

    I still don't understand why the query works, but not as a view.

    Any thoughts?

    My guess is that the view is forcing a data type conversion that...

    May 10, 2012 at 2:35 pm

    #1485977

  • RE: query works but not in a view

    Jeff Moden (5/9/2012)

    PaulB-TheOneAndOnly (5/9/2012)

    If MSTR_END on WHERE clause is causing the issue replace the condition with:

    where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''

    IIRC, that'll make for a non-SARGable search predicate just like in T-SQL....

    May 10, 2012 at 2:33 pm

    #1485976

  • RE: query works but not in a view

    Denise McMillan (5/9/2012)

    In SQL 2008R2 database I'm using openquery and a link to an oracle database. It works ok when run directly, but I created a view with it and...

    May 9, 2012 at 2:32 pm

    #1485350

  • RE: Referential Integrity: Who needs it - right? (Discussion)

    SQL_ME_RICH (5/4/2012)

    The other consideration was their desire for speed over the accuracy of the data. Yes - you read that correctly. :crazy:

    :w00t: Yes, absolutely crazy. Nothing should...

    May 6, 2012 at 7:56 am

    #1483882

  • RE: Production Issues..need help

    Sapen (5/6/2012)

    Last night I have noticed the following errors around 2:00AM.

    There are 10 of these errors:

    The client was unable to reuse a session with SPID, which had been reset for...

    May 6, 2012 at 6:42 am

    #1483874

Viewing 15 posts - 271 through 285 (of 3,061 total)