Marcus Farrugia (3/4/2014)

---

Hi I am receiving the following error while trying to query a .csv file using OpenRowset. I've tried every query style I can think of. I'm...

Save yourself the administrative heartache, if you can, and offload that activity to another database or server instance.

This underlines the reason why it's best to post ddl as well as expected output.

You would have hand this solved many posts ago if you had done that so always...

Just taking a quick glance at the plan, it appears that you have, in a number of instances, significant differences between the estimated and actual rows.

I would start by ensuring...

From the title of the post, it would appear the OP is already using UNION ALL which I wouldn't expect to cause a major slow down unlike it's sibling UNION.

I...

Yes, SSIS stands...

As I said earlier, tSQL won't be your tool of choice for this, in a sql agent job or otherwise.

If this is all new to you then I would keep...

mail2payan (2/18/2014)

---

Hello there,

I am facing a issue in importing CSV file to my MS SQL Table.

Let me explain my problem:

I have 2 tables:- 1# Stock_Symbol 2# Stock_Symbol_Daily_Quotes

In Stock_Symbol there are...

aframiller326 (2/13/2014)

---

Jeff Moden (3/11/2013)

---

I'd have to include FileStream in the same bucket as the "File Path Reference" approach with some reservations. To be sure, I've not used FileStream, yet...

dajonx (2/12/2014)

---

Thank you for your quick response, Eugene.

Regarding the full text index feature, can you please tell me how to use it? I have attempted at creating one, but...

A CLR Procedure will probably be a cleaner and dare I say more elegant way of doing this but if it must absolutely be TSQL then I guess you're limited...

I believe you should be able to query the msdb tables for the information you need.

Maybe this article http://www.bidn.com/blogs/DevinKnight/ssis/2792/identifying-long-running-sql-agent-jobs-script could help you along the way.

Not sure what you mean by not having control over the "values" but wouldn't using CASE to derive the Column values work?

Maybe best to post some ddl and consumable data...

I think you might benefit from reading this book:

http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145

Expands a bit more on Gail's response above.

Just to add to what has already been said.

If you can, do the MS Certifications. I know people rag on them a lot but in cases where you are...