samot-dwarf (1/14/2016)

---

Personally I would have used my script to create the drop / create statements for the FKs, dropped them, changed collation and recreated the FKs. Should be much lesser...

Eric M Russell (12/26/2015)

---

Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in a way...

Eric M Russell (12/26/2015)

---

Solomon Rutzky (12/26/2015)

---

Just out of...

Just out of curiosity, what exactly is this...

mishka-723908 (12/22/2015)

---

It is not yet in place. Currently we have a service that does calculations to populate a table. The developer is asking if we could have a clr...

SQLCLR is not inherently slow. Like most technologies it can be used to do things faster than T-SQL can, or can be used inappropriately and be much slower. Please see...

Hey there. So I found the cause, kinda. It has to do with the NVARCHAR(MAX) datatype, though I am not sure why or how it is only showing up in...

levaif (9/28/2015)

---

Regarding your question about why I use CLR for bcp.exe. I have to automate the usage of bcp, because I have 30 stored procedures where we use this. Till...

levaif (9/28/2015)

---

Sorry, it's a txt file, not cvs.

and the method is

public static int processCMD(string fileName, string arguments)

{

try

{

System.Diagnostics.Process proc = new System.Diagnostics.Process();

proc.StartInfo.FileName = fileName;

...

Jeff Moden (9/25/2015)

---

There's a lot of pre-2005 FUD surrounding xp_CmdShell that still permeates the community. It was a well deserved fear before then. Since 2005, it's a...

Lowell (9/25/2015)

---

when you go outside of a SQL database, SQL uses an account that you would not intuitively expect it to use . even if you are sysadmin +domain admin...

Lowell (9/25/2015)

---

Solomon what about the other direction for a CLR?

if i pulled data into a Datatable and want to send them to disk, how would you do it?

I've...

levaif (9/25/2015)

---

I have another stored procedure where I use another commands, not bcp, and there I haven't any problem. My question...

nikhil.desai1 (9/19/2014)

---

I our SQL server project we are using xp_cmdshell to generate .txt or .csv file. As per SQL sever hardening xp_cmdshell is a security risk. Is there any alternative...

michael.farrow (3/1/2015)

---

In a batch file, I'm using BCP ... || goto ERROR_HANDLING from which I then capture %ERRORLEVEL%. It works perfectly, but sometimes %ERRORLEVEL% is zero, and I was...