tag:blogger.com,1999:blog-3000721125799986885.post7689540253366690808..comments2024-03-28T04:05:20.028-07:00Comments on SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): The Index Tuning DetectiveBrad Schulzhttp://www.blogger.com/profile/01852762873611487368noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3000721125799986885.post-51863851543658357042024-01-14T22:33:14.346-08:002024-01-14T22:33:14.346-08:00I’m really enjoying the design and layout of your ...I’m really enjoying the design and layout of your site.바카라사이트https://www.outlookindia.com/outlook-spotlight/2023년-바카라-사이트-추천-실시간-에볼루션-바카라사이트-순위-top15-news-334941noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-90453437493827788332024-01-14T22:32:18.155-08:002024-01-14T22:32:18.155-08:00I love reading through and I believe this website ...I love reading through and I believe this website got some genuinely utilitarian stuff on it!파워볼사이트https://www.outlookindia.com/outlook-spotlight/2024년-파워볼사이트-추천-순위-안전한-파워볼실시간-게임-사이트-top15-news-334143noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-89018235994323890782024-01-14T22:31:51.209-08:002024-01-14T22:31:51.209-08:00Very great post. I just came across your weblogVery great post. I just came across your weblog카지노사이트https://www.outlookindia.com/outlook-spotlight/2023년-한국을-대표하는-카지노-사이트-best-10--news-326663noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-18624942312270235162024-01-14T22:31:08.368-08:002024-01-14T22:31:08.368-08:00I am looking for some good blog sites for studying...I am looking for some good blog sites for studying. 메이저-토토사이트https://www.outlookindia.com/outlook-spotlight/2023년-11월-메이저-토토사이트-순위-추천-토토-안전놀이터-top15-news-332207noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-14969947528601907462024-01-14T22:30:33.011-08:002024-01-14T22:30:33.011-08:00Its opportunity are so fantastic and working style...Its opportunity are so fantastic and working style so speedy안전 토토사이트https://www.outlookindia.com/outlook-spotlight/2024년-안전-토토사이트-순위-사설-토토사이트-추천-top15-news-328577noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-86526404878214552592022-01-18T21:10:49.305-08:002022-01-18T21:10:49.305-08:00Thank u very much
Opseazy provide
contact us
car...Thank u very much<br />Opseazy provide <br /><a href="https://www.opseazy.com/contact" rel="nofollow">contact us</a> <br /><a href="https://www.opseazy.com/career" rel="nofollow">career</a> <br /><a href="https://www.opseazy.com/blog" rel="nofollow">blog</a> Premhttps://www.blogger.com/profile/07265171566482246692noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-40235188131999339622011-07-27T03:29:15.458-07:002011-07-27T03:29:15.458-07:00Brad,
I'd love to test out your query which ...Brad,<br /> <br />I'd love to test out your query which is looking for index suggestions using the xml namespace. SSMS is telling me though that the following namespaces cannot be found 'qp.query_plan.nodes' along with 'GrpNode.nodes' (Invalid object name) and 'IxNode.value' (possibly ambiguous). Could you help me out there?<br /> <br />Thanks lots.<br /> <br />P.S. I'm still sort of new to this, but my environment is huge and our developers still develop with SQL2000 in their heads on SQL2008 machines. I'm trying to hunt for suggestions (facts) to them to change their techniques and upgrade their query developing style by adding more/better indexes.Reinernoreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-37503911295024463692011-05-12T12:48:37.340-07:002011-05-12T12:48:37.340-07:00@Greg:
It looks like your T-SQL Code has a CHAR(0...@Greg:<br /><br />It looks like your T-SQL Code has a CHAR(0) in it somewhere, and FOR XML does not like that.<br /><br />Remove the processing-instruction stuff from the CROSS APPLY and instead make it say:<br /><br />select BatchCode=qt.text<br /><br />At least this way you can get the text of the batch, but it won't be in a hyperlink and it won't be nicely formatted.<br /><br />You might also want to add a column to the main query that checks for the CHAR(0) within the text:<br /><br />PositionOfChar0=CHARINDEX(CHAR(0),BatchCode)<br /><br />This may help you find the offending code.<br /><br />Let me know how it goes.<br /><br />--BradBrad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-10235619427206054962011-05-12T12:22:59.750-07:002011-05-12T12:22:59.750-07:00The two XML queries work on my staging server but ...The two XML queries work on my staging server but fail on my QA and Production servers with the following error:<br /><br />Msg 6841, Level 16, State 1, Line 5<br />FOR XML could not serialize the data for node 'processing-instruction(q)' because it contains a character (0x0000) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.<br /><br />I glanced at BOL but didn't see a mention of the BINARY BASE64 directive for the CONVERT() function. Is the error perhaps referring to a XQuery conversion function?Greg Faulknoreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-33253875845768807162011-05-07T08:15:19.553-07:002011-05-07T08:15:19.553-07:00Brad,
Nice work with the 'missing include col...Brad,<br /><br />Nice work with the 'missing include columns' query.<br />Thanks for sharing, it works a treat!<br /><br />Indexes that appear to be used can easily be used as springboards for key lookups.<br />Your query nails them down.<br /><br />Keep up the good work!John Alannoreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-22835666694716959202011-05-04T14:19:18.829-07:002011-05-04T14:19:18.829-07:00@Michael and @Kent:
Thanks for the feedback! (An...@Michael and @Kent:<br /><br />Thanks for the feedback! (And great to hear from you, Kent!). The Key Lookup query has been very enlightening for me in what it finds.<br /><br />--BradBrad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-84915817693780065142011-05-04T12:33:15.760-07:002011-05-04T12:33:15.760-07:00Sweet. The key lookup problem is an issue that ha...Sweet. The key lookup problem is an issue that has been near and dear to my heart for some time. I greatly appreciate the article; thank you.<br /><br />:)Kent Waldrophttps://www.blogger.com/profile/11169211720676440554noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-4692570683739701752011-05-02T06:26:33.182-07:002011-05-02T06:26:33.182-07:00Very nice! Immediately useful.
I found some stuff...Very nice! Immediately useful. <br />I found some stuff already (even though I thought I knew this db like the back of my hand).Michael J. Swarthttps://www.blogger.com/profile/05408240220683534698noreply@blogger.com