THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 46 (452 total posts) < 1 second(s)
  • re: DBAs and the Internet of Things

    Yes - I think the job of maintaining databases will continue to change. But I also think that DBAs should seek to leverage new technologies to monitor their systems, meaning that they can then look after more than they ever did. On-prem systems will still need monitoring (to a degree), and there will still be some tasks that are needed in the ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 9, 2015
  • DBAs and the Internet of Things

    Ever since data moved to the cloud, database administrators have wondered what it will mean for their jobs. It doesnt matter whether you are thinking about Infrastructure as a Service, Platform as a Service, Database as a Service, there is some aspect of what a database administrator does that may not exist in the future. And then theres the ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 8, 2015
  • re: Handling special characters with FOR XML PATH('')

    Hi Yogesh, There are quite a few examples above for the syntax. Essentially, it's just @TheXML.value('.','nvarchar(max)') So having done: ... FOR XML PATH(''), TYPE you have a string which looks like an ordinary concatenated string, but is actually XML, with some characters replaced by encoded equivalents. Using the .value() method can take ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 6, 2015
  • re: SSIS Lookup transformation in T-SQL

    That's great, Tarek! :)
    Posted to Rob Farley (Weblog) by Rob Farley on May 21, 2015
  • re: Handling special characters with FOR XML PATH('')

    Rip out that character first, as it's not allowed in XML. Then see how you go.
    Posted to Rob Farley (Weblog) by Rob Farley on May 20, 2015
  • re: Handling special characters with FOR XML PATH('')

    Use: CROSS APPLY (SELECT ( SELECT &nbsp;' ' +LTRIM(RTRIM(Claim_Note)) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM Note_Detail v2 with(nolock) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE v2.num = v1.num and Seq_Num &lt;&gt; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...
    Posted to Rob Farley (Weblog) by Rob Farley on May 20, 2015
  • re: Handling special characters with FOR XML PATH('')

    Hi Ram, Try putting it inside something which you can cast to xml, and then extracting the contents from it. select cast('&lt;t&gt;'+Note+'&lt;/t&gt;' as xml).value('/t[1]','varchar(max)') from dbo.Note;
    Posted to Rob Farley (Weblog) by Rob Farley on May 19, 2015
  • Monitoring skew in PDW

    When you have data stored across several servers, skew becomes very significant. In SQL Server Parallel Data Warehouse (PDW), part of the Analytics Platform System (APS), data is stored in one of two ways distributed or replicated. Replicated data is copied in full across every compute node (those servers which actually store user data), while ...
    Posted to Rob Farley (Weblog) by Rob Farley on May 11, 2015
  • Tuning slow spatial queries in SQL Server

    Even with the right indexes in place, spatial queries in SQL Server are often too slow but they neednt be. Two of the most commonly found patterns of query in the spatial world are when youre looking for the nearest thing to where you are (which Ive written about before), and when youre looking for the points that are within a particular ...
    Posted to Rob Farley (Weblog) by Rob Farley on April 28, 2015
  • SHOWPLAN permission denied even if the database isn’t actually used

    To view a query plan, you need SHOWPLAN permission on the database level at least. You have this if you have CONTROL DATABASE, or CONTROL SERVER, or if you have ALTER TRACE at the instance level. I know this last one because its mentioned in Books Online on the Database Permissions page, not because its particularly intuitive. As a ...
    Posted to Rob Farley (Weblog) by Rob Farley on April 14, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement