Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 19,560 total)

  • RE: Auto Import Stock Price from Yahoo Finance to MS SQL

    I have seen a few other people use StreamInsight for this type of thing. They used it to import Ticker data all day long.

    http://technet.microsoft.com/en-us/library/ee362541.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 6:16 pm

    #1690524

  • RE: Are the posted questions getting worse?

    dwain.c (2/19/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Hearty congratulations on this accomplishment!

    I'm struggling to get to 4000 posts because of all the inane questions being asked lately. 😛

    Yeah but you...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 5:19 pm

    #1690517

  • RE: Max server memory

    Gary Gwyn (2/19/2014)

    If no maximum is set, then SQL uses as much RAM as it needs. You can set a maximum, say 44,032 MB -- allows 4GB for OS...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 3:50 pm

    #1690500

  • RE: Max server memory

    It is a best practice to set a max server memory limit. Right now, you are starving the OS of memory and in the end you could be causing...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 3:45 pm

    #1690497

  • RE: Max server memory

    duplicate thread

    post answers to http://www.sqlservercentral.com/Forums/Topic1543228-1550-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 3:42 pm

    #1690494

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/19/2014)

    And here I thought you were already insane, Jason.

    Congrats

    Ask me again in five minutes and I might have already forgotten, you know how that insanity...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 1:37 pm

    #1690443

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/19/2014)

    stormsentinelcammy (2/19/2014)

    A life long dream to reach that status?

    to become insane - absolutely :w00t:

    Inpainly Sane?

    Thanks

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 1:29 pm

    #1690442

  • RE: Are the posted questions getting worse?

    stormsentinelcammy (2/19/2014)

    A life long dream to reach that status?

    to become insane - absolutely :w00t:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 1:08 pm

    #1690436

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/19/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Congrats!

    One day I'll catch up... 😎

    I don't doubt that.

    Thanks

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:59 pm

    #1690433

  • RE: Are the posted questions getting worse?

    Evil Kraig F (2/19/2014)

    Congratz Jason. May you have many more years of helping people here.

    Thanks SSCertifiable, err Mr Evil Kraig 😀

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:56 pm

    #1690432

  • RE: Append with 0's

    tschuler-738392 (2/19/2014)

    thanks. After looking at your query it made sense. I also just read the information on that Function. Thank you.

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:39 pm

    #1690427

  • RE: Append with 0's

    Here is the code example for the stuff function using a CTE and the provided sample data as well.

    WITH client AS (SELECT 'P1234' AS client_num

    UNION

    SELECT 'C1234' AS client_num

    )

    SELECT STUFF( client_num,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:38 pm

    #1690426

  • RE: Append with 0's

    tschuler-738392 (2/19/2014)

    The string in those fields can start with any Letter not always C or P

    The CTE is provided only as a means to ingest the data you provided. ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:34 pm

    #1690424

  • RE: Append with 0's

    There is also the replace option such as follows.

    WITH client AS (SELECT 'P1234' AS client_num

    UNION

    SELECT 'C1234' AS client_num

    )

    SELECT REPLACE(client_num,LEFT(client_num,1),LEFT(client_num,1) + '00') AS client_num

    FROM client;

    Stuff would probably be a little simpler.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:31 pm

    #1690420

  • RE: Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

    Solomon Rutzky (2/19/2014)

    SQLRNNR (2/19/2014)

    Alan.B (2/19/2014)

    SQLRNNR (2/19/2014)

    Great article. Very useful information.

    One question I think could be answered and would be very useful to those noobs to CLR.

    How do you get...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 19, 2014 at 12:26 pm

    #1690416

Viewing 15 posts - 3,571 through 3,585 (of 19,560 total)