Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 7,636 total)

  • RE: db migration

    Ballad (6/9/2009)

    We just got done this and it was a real F'ing nightmare man. Use the wizard if you can and if not then check out dts xchange from...

    June 9, 2009 at 11:33 am

    #1006940

  • RE: O(n) , O(n log n), O(n^2)

    So we should avoid pseudo cursor. Right?

    I never said anything like this.

    1) It will be treated as internal cursor. i.e it will perform looping internally.

    AFAIK all set processing in...

    June 9, 2009 at 11:12 am

    #1006905

  • RE: O(n) , O(n log n), O(n^2)

    karthikeyan (6/9/2009)

    1) SQL Server apparently (based on my tests) already does the "buffer-extension" trick available to mutable strings. Unfortunately, the Extension trick does NOT solve the O(n^2) problem,

    If...

    June 9, 2009 at 11:02 am

    #1006891

  • RE: O(n) , O(n log n), O(n^2)

    karthikeyan (6/9/2009)

    RBarryyoung and Gail,

    Big O notation means the steps to complete a problem. Right?

    Sort of. Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without...

    June 9, 2009 at 10:50 am

    #1006870

  • RE: SqlServer.Batch.Parser dll issue between 2005 to 2008 (version issue)

    I believe that the SMO-related stuff gets installed along with the corresponding SQL Client tools. You customer situation can probably be fixed by installing the SQL Server 2005 Client...

    June 9, 2009 at 10:19 am

    #1006844

  • RE: Function runs slowly, but each half run separately runs quickly

    Glad we could help!

    June 9, 2009 at 10:13 am

    #1006842

  • RE: Tables

    Nkagisang Bosaletse (6/9/2009)

    i'M USING CRYSTAL REPORTS10

    While I am not a Crystal Reports expert, I have used it before and IIRC, it should be able to handle the parent-child relationship here...

    June 9, 2009 at 10:08 am

    #1006838

  • RE: Recursive Triggers

    Peter Lake (6/9/2009)

    ...

    In this case the user just added the part with the Part FK of 1. A trigger on the Job table then goes to the Bill of Material...

    June 9, 2009 at 9:52 am

    #1006823

  • RE: Please advice on learning replication.

    I also want to point out that it is possible for a Server Instance to replicate to itself, as long as it's a different database. In fact the first...

    June 9, 2009 at 9:40 am

    #1006806

  • RE: Are the posted questions getting worse?

    WayneS (6/8/2009)

    Hey Barry... how many more articles do you have planned for your "15 ways to lose your cursor" series, and when would the next one be publishing? It's been...

    June 9, 2009 at 12:56 am

    #1006473

  • RE: Week Numbers and week start dates

    OK. How can we help?

    June 9, 2009 at 12:53 am

    #1006471

  • RE: Performance Issues with Dynamic SQL

    Reddy B (6/8/2009)

    Thanks a lot, Barry. I really appreciate all of your help. You blog pointed me to the right direction.

    Great Job.

    -B

    Glad we could help. 🙂

    June 9, 2009 at 12:15 am

    #1006455

  • RE: Updating a view with an INSTEAD OF trigger

    Could you also provide the Indexed View definition and the related table definitions?

    Angelindiego (6/8/2009)

    Hi all...I need your assistance here!

    I need to update a view. It has an UPDATE trigger...

    June 8, 2009 at 6:33 pm

    #1006377

  • RE: Performance Issues with Dynamic SQL

    There are good reasons to go both ways (any of the three ways, actually), it depends on you needs and goals. The advantage of the multiple DB approach is...

    June 8, 2009 at 6:23 pm

    #1006373

  • RE: CASE STATEMENT in WHERE CLAUSE

    You are trying to return boolean truth values in your case expression, but SQL has no such datatype, so you can't do that. As you suggested, the SOP here...

    June 8, 2009 at 6:02 pm

    #1006369

Viewing 15 posts - 2,161 through 2,175 (of 7,636 total)