Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 5,502 total)

  • RE: How to convert MySQL to SQL 2k5?

    Joie Andrew (5/20/2010)

    A quick serch in MSDN brought this back:

    Guide to Migrating from MySQL to SQL Server 2005

    I've seen that too but didn't feel like a human search engine today......


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 20, 2010 at 3:48 pm

    #1170485

  • RE: Using xml param type very slow

    I second Stefan regarding not to trust the % measures from an execution plan.

    Especially if the query itself doesn't take that much time (like in your case).

    The main reason is...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 20, 2010 at 3:45 pm

    #1170480

  • RE: How to convert MySQL to SQL 2k5?

    What links/hints/information did you get using a simple Google search?

    It seems like there is a load of information out there...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 20, 2010 at 3:34 pm

    #1170473

  • RE: Date Comparison Not Selecting Any Rows

    Your query itself seems to be valid in terms of syntax.

    You should narrow the problem down in SSMS and build the dynamic string later.

    My guess would be there are either...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 20, 2010 at 3:20 pm

    #1170465

  • RE: Xquery on XML column

    Something like this?

    SELECT

    Y.value('@Guid[1]','char(37)') AS Guid_,

    Y.value('(.)[1]','varchar(100)') AS Property_

    FROM @XML.nodes('Root/Property') X(Y)


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 20, 2010 at 1:41 pm

    #1170423

  • RE: question inserting nchar(1) from a hex value

    It depends.

    If you want to store the integer value converted to character then you can't, since the value '94' has two character.

    But if you want to store the ASCII character...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 19, 2010 at 10:04 am

    #1169558

  • RE: Crosstab based on row counting

    Based on a numbers (or tally) table I'd use the following logic:

    ;

    WITH cte AS

    (

    SELECT

    n,

    (ROW_NUMBER() OVER(ORDER BY n)-1) % 5 +1 AS c,

    (ROW_NUMBER() OVER(ORDER BY n)-1) /...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 19, 2010 at 9:59 am

    #1169549

  • RE: How do I count the occurrences of a sequence of records

    This was actually my first thought before I stumbled over the OP's requirement at the end of his first post:

    I will also need to run this query on a SQL...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 5:28 pm

    #1169170

  • RE: Verifying Data against a list of symbol characters

    Jeff Moden (5/18/2010)

    lmu92 (5/18/2010)

    Would something like the following help?

    SELECT * FROM

    (

    SELECT 'Smith John' AS lastname UNION ALL

    SELECT 'S#ith Jane' UNION ALL

    SELECT '\ Jim' UNION ALL

    SELECT 'Anderson Ken' UNION ALL

    SELECT 'Smith-Barny...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 5:04 pm

    #1169167

  • RE: How do I count the occurrences of a sequence of records

    bteraberry (5/18/2010)

    That wouldn't be hard to check for if that's part of the requirements. What he said was

    if a "re-open" occurs followed at some point by a "ready...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 4:50 pm

    #1169162

  • RE: The function takes forever to run for 13,000 data

    Lowell (5/18/2010)

    damn Lutz; your's looks much better than mine, so i decline to post it 🙂

    very nice job.

    blade, if you look at Lutz's contribution, it's doing all your updates as...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 4:41 pm

    #1169158

  • RE: How do I count the occurrences of a sequence of records

    Nice and clean solution.

    But if you have the following scenario of two 'Re-open' without a 'Ready for build' in between, you might get wrong results:

    ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 4:34 pm

    #1169153

  • RE: The function takes forever to run for 13,000 data

    Here's a Q&D (quick and dirty) CTE approach using your INSERT statement to define the CTE.

    The final SELECT actually uses a bunch of CASE statement to cover your various...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 4:27 pm

    #1169147

  • RE: Procedure for Removing Obsolete SQL Objects from Production Environments

    The main question would be: What would you define as "obsolete SQL objects"?

    I think you can only refer to views, procedures and/or functions that would use tables or columns that...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 4:00 pm

    #1169136

  • RE: How do I count the occurrences of a sequence of records

    It seems like a job for the "quirky update" method as described in Jeffs article[/url].

    I recommend you read the article and try to modify it to meet your requirements.

    If...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 18, 2010 at 3:12 pm

    #1169130

Viewing 15 posts - 3,466 through 3,480 (of 5,502 total)