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

Yeah but you...

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...

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...

duplicate thread

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

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

Inpainly Sane?

Thanks

to become insane - absolutely :w00t:

I don't doubt that.

Thanks

Thanks SSCertifiable, err Mr Evil Kraig 😀

You're welcome.

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,...

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

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.

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...