In some cases both are required for complimentary functions. I am only commenting on where they overlap, that R has become the more popular choice.

Python is losing market share to R every day in data science circles and PowerShell is a more strategic language on Windows for handling those pesky sys admin tasks (I...

Sergiy (12/14/2015)

---

Do developers really have the same...

Since it runs on the same machine as the engine NTLM will be used, not Kerberos.

depends how its used. you have to look at the execution plan tonsee ot but its in the intermediate steps of the plan.

a linear example: imagine a UDF used...

no doubt refactoring the UDFs out of the equation should be a long term goal towards better performance and more predictable scaling. woild love to get to the bottom on...

Fandy08 (12/10/2015)

---

Orlando Colamatteo (12/8/2015)

---

agree it is counterintuitive. rebuilding indexes amd stats (even if only a subset of stats) should not hurt things.

any noticeable changes (increases or decreases) in data volumes...

agree it is counterintuitive. rebuilding indexes amd stats (even if only a subset of stats) should not hurt things.

any noticeable changes (increases or decreases) in data volumes on or arounf...

it can affect row estimates and therefore can result in inefficient execution plan choices

All index statistics will be uodated when the index is rebuilt but column statistics need...

You're welcome. Bing can help. I specifically included the names of the SSIS Tasks and Components you would want to research. In .NET you can begin researching StreamWriter.

Yours:

Add "|" or "\t" after -t and I bet your...

One option: Write an SSIS Package to write the binary to disk using the Export Column transform inside a Data Flow Task.

Another option: Write a SQLCLR Procedure or Function to...

"L1" is subjective depending on the shop so you'll need to go off the job description. Can you post the "skills required" or "qualifications" here? From there we can map...

The Death By UDF article from Kevin is focused primarily on the misuse and overuse of Scalar-valued Functions (SVFs) and Multi-statement Table-valued Functions (mTVFs). Inline Table-valued Functions (iTVFs) do not...