Viewing 15 posts - 136 through 150 (of 2,458 total)
-- Itzik Ben-Gan 2001
February 28, 2018 at 1:09 pm
-- Itzik Ben-Gan 2001
February 28, 2018 at 12:42 pm
WHERE @SearchVal NOT LIKE '%[^0-9.]%'
AND LEN(@SearchVal) - LEN(REPLACE(@SearchVal,'.','')) < 2
-- Itzik Ben-Gan 2001
February 28, 2018 at 12:27 pm
-- Itzik Ben-Gan 2001
February 28, 2018 at 11:38 am
The solution will involve ROW_ NUMBER() OVER (PARTITION BY empnum ORDER BY email DESC, LEN(<name field you're measuring> DESC)
-- Itzik Ben-Gan 2001
February 28, 2018 at 11:36 am
-- Itzik Ben-Gan 2001
February 1, 2018 at 12:03 pm
A few things:
1. The plan you attached is the Estimated Plan which will not be helpful here
2. A TOP (10) - that will affect the execution plan, what...
-- Itzik Ben-Gan 2001
January 31, 2018 at 1:27 pm
It depends on how much far back you want to go. I don't think I've ever done a point-in-time restore to the any system database so, for me, simple is...
-- Itzik Ben-Gan 2001
January 29, 2018 at 12:45 pm
-- Itzik Ben-Gan 2001
January 24, 2018 at 8:37 am
I'm in Chicago, IL and can only speak about what I've seen in America. From what I'e seen, more and more companies are allowing remote work. Our DBA works from...
-- Itzik Ben-Gan 2001
January 23, 2018 at 2:01 pm
-- Itzik Ben-Gan 2001
January 18, 2018 at 2:43 pm
-- Itzik Ben-Gan 2001
January 9, 2018 at 10:41 pm
-- Itzik Ben-Gan 2001
January 8, 2018 at 10:00 pm
-- Itzik Ben-Gan 2001
January 8, 2018 at 11:39 am
I guessed correctly. Good question!
-- Itzik Ben-Gan 2001
January 7, 2018 at 5:26 pm
Viewing 15 posts - 136 through 150 (of 2,458 total)