The following is chapter 2 in its entirety from my Common Table Expressions book. What is a Common Table Expression? The first time I tried snowboarding after being a skier for many years it was very uncomfortable. Everything was difficult, riding the snowboard was strange and I ended up with my face in the snow more times than I can …
Using TSQL to Read an RSS Feed Fri, 29 Jan 2021Most blogs have a RSS feed of some kind. The RSS feed is usually comprised of XML with a list of the most recent posts. I though it would be handy to try using TSQL to see who has bee Read more… Ask a question about Database Corruption Wed, 27 …
Most blogs have a RSS feed of some kind. The RSS feed is usually comprised of XML with a list of the most recent posts. I though it would be handy to try using TSQL to see who has been blogging about what lately. I created two procedures, the first one called httpGET, and another one called LatestBlogPosts. The httpGET …
Now is your chance to ask a question about corruption in SQL Server databases. We will do our best job of answering those questions on our February webcast on database corruption. Do you have a question about the output from DBCC CheckDB? Seeing a strange error in your SQL Server logs? Is your SQL Server sending alerts related to corruption? …
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up with a way to speed up concatenation if you need to build really long strings. What the previous show as that the longer the string gets the slower the concatenation is. So instead we declare …
Performance: Faster way to concatenate longer string Read more »
String concatenation in SQL Server can be pretty quick but under certain circumstances it can really slow down. Something to be aware of if you are working with larger varchar(max) values that need to be appended to using concatenation in TSQL. The experiment: Using a VARCHAR(MAX) variable, start with it empty, then in a loop concatenate another string to it …
Due to the confidentiality we have with our clients we rarely get to share some of the great work we do outside of a “We have done that before” or “We saw that before a month ago with another customer and helped them with it” however sometimes a customer gives us a reference a reference to share. Completing a project …
The following has been republished from my Common Table Expressions book. Chapter 1. Memory Tables There was a 1996 Michael Keaton movie called Multiplicity where he duplicates himself to get more work done. It first started out that he just needed help to finish up his work and be able to attend his child’s ballgame. The theme of the movie …
Microsoft has recently released a security patch for all supported version of Microsoft SQL Server. These updates are fixing where an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. From the Microsoft security bulletin: Data can be sent over a network to an affected Microsoft SQL Server instance that may cause code to …
With the variety of clients that we work with at Stedman Solutions, one of our service products that has come from listening to our customers is the SQL Server Mentoring package. This is a really good fit for some customers who just need an occasional hand with something on their SQL Server. I was just working with a new client …