Viewing 15 posts - 166 through 180 (of 392 total)
It seems to me that there is a trend to have most, if not all, of the business logic layer in code (Java, .NET, etc.) and the database is used...
June 20, 2017 at 6:06 am
Having grown up in the days of "green" screens (green text on dark screens), I've always preferred dark backgrounds and high-contract fonts for all-day working. My eyes have always been...
June 2, 2017 at 5:48 am
April 26, 2017 at 10:04 am
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
Viewing 15 posts - 166 through 180 (of 392 total)