Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 5,502 total)

  • RE: get number of days from two dates

    I'm confused: you started a new thread after getting several replies on the other thread?

    (http://www.sqlservercentral.com/Forums/FindPost1171968.aspx)

    Why?

    Edit: Sorry, Remi. Didn't see your reply. :blush:


    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]

    September 8, 2011 at 11:25 am

    #1378796

  • RE: Sequence creation

    Jeff Moden (9/7/2011)

    SQLServerMS (9/7/2011)

    Hi,

    I need to populate the values for a column in a sequential manner as below, these need to be auto generated:

    i1st it starts with

    000001

    000002

    ......

    999999

    A00001

    A00002

    ......

    A99999

    B00001

    ......

    B99999

    ......

    Z99999

    ZA0001

    ......

    ZA9999

    ......

    ZZZZZZ

    How can i...


    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]

    September 8, 2011 at 11:18 am

    #1378786

  • RE: Covert auto ID to file name

    Something like

    SELECT RIGHT(100000000 + ID, 8)

    FROM YourTable


    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]

    September 7, 2011 at 12:28 pm

    #1378212

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    SQLRNNR (9/7/2011)

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    OK, who had 9/7/2011 in the end of the world pool?

    Hmm. Where's the incentive to win?

    You get a billboard posted by a...


    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]

    September 7, 2011 at 12:20 pm

    #1378203

  • RE: Yeah! my first real corrupt DB

    fails on Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86)

    with

    Msg 4060, Level 11, State 1, Line 65536

    Cannot open database "Corrupt" requested by the login. The login failed.

    Msg...


    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]

    September 7, 2011 at 10:08 am

    #1378095

  • RE: Insert data with select statement is very slow.

    Please attach the actual query since the execution plan does not show the full query.

    My pot shot would be this task would benefit from a divide'n'conquer approach (based on the...


    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]

    September 6, 2011 at 1:15 pm

    #1377650

  • RE: Monitor SP Parm Lengths

    I just hope the logic that's being used is protected against SQL injection... But that's a different story.

    In the scenario described I would run a server side trace. While running...


    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]

    September 6, 2011 at 1:01 pm

    #1377640

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/6/2011)

    Thanks Gus.

    Yes, I live in a paradise. 🙂 White sandy beaches. No winter, No shark attacks yet..!!! 🙂

    It is also famous for a place called Campo...


    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]

    September 6, 2011 at 12:29 pm

    #1377628

  • RE: Are the posted questions getting worse?

    GSquared (9/6/2011)

    LutzM (9/6/2011)

    Ninja's_RGR'us (9/6/2011)

    ...

    Here's the full album from that day! Enjoy and dream on!

    http://s1123.photobucket.com/albums/l551/Ninja_RgRus/Sunrise%20August%2023rd%202011/

    Do you know it seems like you're living in a place others would pick for...


    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]

    September 6, 2011 at 12:26 pm

    #1377625

  • RE: Monitor SP Parm Lengths

    You could run a server side trace (PROFILER trace, but not using the GUI) to capture the calls of the sproc. This will show the actual parameter used.

    Another option could...


    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]

    September 6, 2011 at 12:20 pm

    #1377620

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (9/6/2011)

    ...

    Here's the full album from that day! Enjoy and dream on!

    http://s1123.photobucket.com/albums/l551/Ninja_RgRus/Sunrise%20August%2023rd%202011/

    Do you know it seems like you're living in a place others would pick for vacation? Do...


    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]

    September 6, 2011 at 12:09 pm

    #1377609

  • RE: Query issue

    Is V_SMPN_gerentes a view? If so, please post the view defintion, too.


    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]

    September 6, 2011 at 12:02 pm

    #1377602

  • RE: how much $$$ saved !!!

    @Remi:

    That's what I call quite an achievement!! Awesome!

    My personal "records":

    1) a search function frequently called from an application from 30+ seconds to less than half a second (moved the queries...


    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]

    September 6, 2011 at 11:56 am

    #1377598

  • RE: how much $$$ saved !!!

    The cost saving in terms of hardware most probably is not significant enough to be measured in $$$. Total processing time is about 30min/day before and after.

    Is there any other...


    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]

    September 6, 2011 at 9:32 am

    #1377511

  • RE: DCOM was unable to communicate with the computer xxxxxxxx using any of the configured protocols

    The easiest answer: use google (search string "DCOM was unable to communicate with the computer").


    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]

    September 6, 2011 at 1:53 am

    #1377208

Viewing 15 posts - 1,006 through 1,020 (of 5,502 total)