Viewing 15 posts - 166 through 180 (of 389 total)
To be honest, I'm rather suspicious of the whole "data science" aspect. In my humble opinion, much of what I've done over my career could be considered "data science" with...
April 26, 2017 at 6:04 am
Jeff, that's pretty amazing! I have truly blown away by the performance this provides. Using an iTVF is something I would not have considered. This also provides me with ideas...
March 14, 2017 at 5:50 am
March 13, 2017 at 7:49 pm
March 10, 2017 at 12:54 pm
March 9, 2017 at 1:13 pm
DROP FUNCTION IF EXISTS dbo.FancyDateDiff;
go
CREATE FUNCTION dbo.FancyDateDiff
...
March 9, 2017 at 12:14 pm
March 8, 2017 at 2:47 pm
March 8, 2017 at 2:09 pm
This appears to work
DECLARE @mytable TABLE(ColumnA INT, ColumnB CHAR(1))
INSERT...
March 3, 2017 at 10:08 am
March 3, 2017 at 8:36 am
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER BY ColumnB) +
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER...
March 3, 2017 at 8:33 am
Actually, let me clarify it a bit more and simplify the situation more succinctly:
March 3, 2017 at 5:45 am
SELECT a.*
FROM dbo.ComplexQuery AS a
WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION...
March 3, 2017 at 5:28 am
March 3, 2017 at 5:27 am
While I've most likely forgotten a number of them, these are the ones that stick out in my mind most readily:
BASIC (DEC...
February 24, 2017 at 6:53 am
Viewing 15 posts - 166 through 180 (of 389 total)