Viewing 15 posts - 181 through 195 (of 404 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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 14, 2017 at 5:50 am
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 13, 2017 at 7:49 pm
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 10, 2017 at 12:54 pm
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 9, 2017 at 1:13 pm
DROP FUNCTION IF EXISTS dbo.FancyDateDiff;
go
CREATE FUNCTION dbo.FancyDateDiff
...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 9, 2017 at 12:14 pm
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 8, 2017 at 2:47 pm
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 8, 2017 at 2:09 pm
This appears to work
DECLARE @mytable TABLE(ColumnA INT, ColumnB CHAR(1))
INSERT...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 10:08 am
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 8:36 am
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER BY ColumnB) +
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 8:33 am
Actually, let me clarify it a bit more and simplify the situation more succinctly: LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 5:45 am
SELECT a.*
FROM dbo.ComplexQuery AS a
WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 5:28 am
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
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...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
February 24, 2017 at 6:53 am
Viewing 15 posts - 181 through 195 (of 404 total)