Feedback is Encouraged

Question

Post reply

Feedback is Encouraged

Steve Jones - SSC Editor

SSC Guru

Points: 736270
More actions
December 1, 2012 at 11:03 am

#151154

Comments posted to this topic are about the item Feedback is Encouraged

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

quagmired Old Hand Points: 324 More actions · Answer 1

CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736270

December 2, 2012 at 1:02 pm

#1564706

What's broken? It seems to work for me.

quagmired Old Hand Points: 324 More actions · Answer 3

SSMS 2012, results to grid, with the option to quote values containing the column delimiter. Why one wouldn't want to do that, among other things, is beyond me:

select

','

,'"'

,'

'

,',"

'

Surely, this is by no means an important feature (although quick and useful), but correct CSV output is so dirt simple to implement (case when value like '%[,"

]%' then '"' + replace(value,'"','""') + '"' else value end), it is very irritating that SSMS even has the option to save as (broken) CSV.

If enough folks ask for it...

Are there any other areas where SQL fails with CSV format? Bulk import?

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

Interesting. Didn't know that was broken. I'm sure this isn't on purpose. Have you reported this on Connect?

quagmired Old Hand Points: 324 More actions · Answer 5

I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."

The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything.

"Interoperability with non-MS tools? We sure won't make it easy!"

Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 6

fname lname-1111520 (12/2/2012)

I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."

The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything.

"Interoperability with non-MS tools? We sure won't make it easy!"

Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files%5B/quote%5D

+1000

Ah... a kindred spirit!

I agree... why bother with feedback if the answer to many of the things you'd like to see is a referral to a tool that you don't want to use or can't use because of some restriction within the company? And, it IS a standard answer. SSIS doesn't always represent the needs of someone doing even simple ETL/File Import/Export of data stored in SQL Tables.

The other dangerous thing is that if they ever do an improvement based on feedback, they might deprecate something useful in the process. For example, I'm still scared to death that they'll deprecate xp_CmdShell in favor of the overcomplications of PowerShell. Don't get me wrong... PowerShell is a great tool for certain things. I just don't need it for simple file handling. I've still got lots of ETL code out there that keeps chugging away even though things like DTS went the wayside for SSIS, etc, ad infinitum.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

chrisn-585491 SSCoach Points: 16006 More actions · Answer 7

After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... 🙁

TravisDBA SSCoach Points: 15780 More actions · Answer 8

chrisn-585491 (12/3/2012)
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... 🙁

Microsoft not listening to its users, now there is a novel concept.:-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 9

chrisn-585491 (12/3/2012)
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... 🙁

"Love the "ribbon"... or else!" 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 10

chrisn-585491 (12/3/2012)
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... 🙁

I'm not sure I agree that Microsoft isn't listening. There are plenty of people that love the ribbon interfaces and many that like Win 8. It's a radical change from previous tries, and I like that.

Users get an opinion, and I'm sure there is discord inside Microsoft as to how much that opinion matters, but I have seen changes come from Connect, and I have seen Microsoft implement new features based on user feedback.

Alexander Kuznetsov SSCrazy Points: 2217 More actions · Answer 11

Feedback is encouraged? Not very much IMO. The following two really efficient ways to communicate feedback are completely closed.

1. Tools such as SSIS and SSMS are "free", which means that we pay for them whether we use them or not. This means that we cannot vote with our money.

2. Code review of closed source is not possible. This is a very common way of getting feedback in other environments.