Viewing 15 posts - 61 through 75 (of 499 total)
xsevensinzx (6/13/2016)
Question is, why should I use this over the other options with Python and SQL Server?
if you want to use SMO objects, you need .NET support. CPython doesn't...
June 13, 2016 at 7:38 am
simon.barnes (6/10/2016)
g.britton (6/10/2016)
June 10, 2016 at 12:22 pm
simon.barnes (6/10/2016)
ronmoses (4/2/2015)
INCREDIBLEmouse (4/2/2015)
Why not, cross apply (something) as SomethingDescriptiveButNotThisLong
I also prefer at least semi-descriptive table aliases, just to help me keep track of where different values are coming from....
June 10, 2016 at 11:31 am
t.franz (6/10/2016)
- minus point for the usage of [dbo].[udfBuildISO8601Date] (UDFs are slow); there is a built in function DATEFROMPARTS() with the same syntax, that outputs a date. If...
June 10, 2016 at 11:24 am
John Hick-456673 (6/10/2016)
What about using the APPLY in the CTE?
If it leads to DRYer, more maintainable code, count me in! Why not take the example and rework it as you...
June 10, 2016 at 8:00 am
Aaron N. Cutshall (6/10/2016) [snip] Still, I'd take clarity over cleverness any day provided performance and results are not impacted.
As do I! Though I don't consider the use of CROSS...
June 10, 2016 at 7:43 am
Aaron N. Cutshall (6/10/2016)
June 10, 2016 at 7:19 am
fregatepllada (6/9/2016)
HOW about Common Table Expression expressions? You should be able to use them in View definition 🙂 And I believe that they performed are BETTER than CROSS APPLY
As far...
June 10, 2016 at 6:49 am
Just to quickly answer the final question:
So, is anyone doing CI with SQL server yet?
These days, it seems everyone is doing CI with SQL Server. Redgate (sponsors of this...
June 8, 2016 at 7:06 am
Steve Jones - SSC Editor (3/11/2016)
March 12, 2016 at 5:56 am
n.arley.dealey (3/11/2016)
If you try to use PS in the same ways you would use Python, or...
March 11, 2016 at 12:49 pm
(sigh!) Once again, I find myself wishing PS was still-born. Microsoft already had a viable alternative in IronPython (first appeared September 5, 2006) which is a far more capable...
March 11, 2016 at 8:16 am
Good observations! FOSS is no more or less secure than any other software. The maxim "given enough eyeballs, all bugs are shallow" is true IFF there are lots...
March 3, 2016 at 7:37 am
I don't want things public. That creates issues. But they need to be able to be audited, independently.
.
I want all algorithms public. Algorithms published in peer-reviewed journals have a greater...
March 1, 2016 at 9:48 am
An algorithm is nothing but math. How can it be dangerous? If the math is correct (how about E=mc^2?) it is what is it is. The fact...
March 1, 2016 at 7:12 am
Viewing 15 posts - 61 through 75 (of 499 total)