SQL Bits Mar 2022
SQLBits March 8 - 12 London Excel www.sqlbits.com-
Recent Posts
- Setting up a big query service account.
- Searching for underscores with LIKE
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 2
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 1
Archives
Categories
Meta
Tag Archives: Performance tuning
Subqueries for XML blobs without self-referencing
One of the issues I see several times within SQL Server is people creating SQL Subqueries that reference the parent query so that an XML blob can be created. In this example The simple table query returns the table contents … Continue reading
XML .value simple syntax
There are several ways to get .value to extract an item of information from xml. in the following article I will show some of the syntax and reasons why some methods are better than others. All the calls in this … Continue reading
Reducing size of a nonclustered index with Filtering
SQL Server 2008 has a very nice new feature that enables a partial index to be created based on a specific where clause. I have recently used this as an solution checking a table that contained an isSent flag. by creating a … Continue reading