Viewing 15 posts - 136 through 150 (of 10,144 total)
January 31, 2019 at 6:31 am
I have a strange issue. I have a table UserActivity with 2 columns, UserId and...
January 29, 2019 at 2:08 am
January 28, 2019 at 1:22 am
Finally, four conditions to test:
without preagg, single key clustered index: stream aggregate, 00:01:30 January 25, 2019 at 3:50 am
without preagg, dual key clustered index:
January 25, 2019 at 3:41 am
January 25, 2019 at 3:30 am
I see Grant,...
January 24, 2019 at 8:37 am
January 24, 2019 at 8:22 am
January 24, 2019 at 7:56 am
Cluster the table by timestamp (if that's how you (almost) always query...
January 24, 2019 at 6:36 am
This other one does the same. I know an MVP they convinced to...
January 24, 2019 at 6:30 am
Untested:
SELECT
e.FirstName,
e.SecondName,
x.Pay_Date
FROM Employee e
CROSS APPLY ( -- x
SELECT Pay_Date = MAX(Pay_Date)
FROM ( -- d
SELECT e.Pay_Date
UNION ALL
SELECT MAX(Pay_Date)...
January 24, 2019 at 1:42 am
January 22, 2019 at 2:57 am
Excellent article, very thorough. Thanks for sharing this.
January 22, 2019 at 1:40 am
Viewing 15 posts - 136 through 150 (of 10,144 total)