Viewing 15 posts - 601 through 615 (of 7,168 total)
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.
December 14, 2015 at 10:56 pm
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...
December 14, 2015 at 9:19 pm
Sergiy (12/14/2015)
ScottPletcher (12/14/2015)
They should have the same level of permission in a test environment that they do in production, otherwise you haven't tested security, right?
Do developers really have the same...
December 14, 2015 at 8:04 pm
Since it runs on the same machine as the engine NTLM will be used, not Kerberos.
December 14, 2015 at 4:52 pm
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...
December 14, 2015 at 7:35 am
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...
December 12, 2015 at 6:28 am
Fandy08 (12/10/2015)
Orlando Colamatteo (12/8/2015)
any noticeable changes (increases or decreases) in data volumes...
December 11, 2015 at 6:28 pm
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...
December 8, 2015 at 9:03 am
it can affect row estimates and therefore can result in inefficient execution plan choices
December 7, 2015 at 2:00 pm
Fandy08 (12/7/2015)
I rebuilt all indexes, non only PKs, that causes stats update automatically, is it true?
All index statistics will be uodated when the index is rebuilt but column statistics need...
December 7, 2015 at 6:51 am
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.
December 7, 2015 at 12:59 am
Yours:
BCP "select * from MyTable WHERE date_start_lead between '2014-07-01' AND '2014-07-31'" queryout G:\Leads3.txt -SUSW2DW1 -T -k -dEDW -c -t
Add "|" or "\t" after -t and I bet your...
December 7, 2015 at 12:49 am
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...
December 7, 2015 at 12:33 am
"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...
December 7, 2015 at 12:28 am
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...
December 7, 2015 at 12:26 am
Viewing 15 posts - 601 through 615 (of 7,168 total)