Viewing 15 posts - 14,941 through 14,955 (of 59,063 total)
May 26, 2017 at 11:43 am
Heh... I absolutely agree that learning new things is essential in this industry. For many of the DBAs and Developers that I've interviewed over the last decade, I would suggest...
May 26, 2017 at 11:23 am
BWAAAA-HAAAA!!!! Too funny! I just saw Mark's tagline in his signature line.
Deja View - The strange feeling that somewhere, sometime you've optimised this query before.
I'm thinking...
May 26, 2017 at 11:12 am
Studying Mark's good solution for this, the code has an interesting parallel in T-SQL known as the "CROSSTAB".
Just a bit of a followup to help those that...
May 26, 2017 at 10:49 am
I only came to this starting point:
Select PlanXML.xmlnode.value('@FieldName',...
May 26, 2017 at 7:42 am
This should give you what you want
WITH XMLNAMESPACES ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' as p)
SELECT...
May 26, 2017 at 7:35 am
May 25, 2017 at 11:07 am
May 25, 2017 at 9:02 am
Gosh... this article started out good with code that you could copy'n'paste to setup the test table. Why didn't you continue that with the remaining code examples instead of using...
May 25, 2017 at 8:55 am
RonKyle - Wednesday, May 24, 2017 7:11 AMIt's a third party software to record telephony information.
It sounds like you should invite...
May 24, 2017 at 9:06 am
May 24, 2017 at 9:03 am
May 24, 2017 at 9:01 am
Viewing 15 posts - 14,941 through 14,955 (of 59,063 total)