Viewing 15 posts - 1,576 through 1,590 (of 4,820 total)
Since there's been nothing posted to guide anyone's further efforts, here's my guess:SELECT d.*, ROW_NUMBER() OVER(PARTITION BY d.Empid ORDER BY d.phonetype DESC) AS RowNum
FROM (
VALUES (1999993, 'CELL', '494757587838'),
(1999993,...
April 4, 2018 at 12:23 pm
April 4, 2018 at 6:44 am
We'd need a LOT more detail. One question I'll ask because you mentioned cxpacket is whether you have any linked servers involved in your queries? That can be problematic if...
April 4, 2018 at 6:25 am
April 4, 2018 at 6:21 am
I can't imagine any DBA allowing an app to stop relying on stored procedures. If the stored procedures aren't performing well, that can be addressed, as it's not the nature...
April 3, 2018 at 1:49 pm
April 3, 2018 at 12:40 pm
April 3, 2018 at 12:10 pm
April 3, 2018 at 12:04 pm
April 3, 2018 at 11:59 am
How many DBA's does it take to change a light bulb?
One to tell the developers to do it, and a half dozen BAs to figure out which light...
April 3, 2018 at 11:46 am
If a DBA pulls a trigger, did he just commit suicide?
April 3, 2018 at 11:41 am
Two programmers walk into a bar.... the third one ducks...
April 3, 2018 at 11:41 am
April 3, 2018 at 11:06 am
Viewing 15 posts - 1,576 through 1,590 (of 4,820 total)