Some simple examples of querying xml with sql
XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I...
2015-06-30 (first published: 2015-06-24)
2,910 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
Some simple examples of querying xml with sql
XML is a beast if you’ve never tackled it. Here are some simple examples of what I discovered as I...
2015-06-24
291 reads
Enabling Instant File Initialization
Found a couple good walkthroughs on enabling instant file initialization. However, I'm becoming more familar with the nuances of various...
2015-06-01
787 reads
Enabling Instant File Initialization
Found a couple good walkthroughs on enabling instant file initialization. However, I’m becoming more familar with the nuances of various...
2015-05-22
646 reads
Upgrade from SQL 2014 Evaluation to Developer Edition
Couldn’t find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted...
2015-05-04
558 reads
Upgrade from SQL 2014 Evaluation to Developer Edition
Couldn't find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted...
2015-05-04
2,602 reads
Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...
I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of...
2015-04-30
1,625 reads
Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…
I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of...
2015-04-30
832 reads
Restoring a database that doesn’t exist
When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t...
2015-04-28
262 reads
Restoring a database that doesn't exist
When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't...
2015-04-28
2,278 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers