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,907 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
286 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
786 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
639 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
556 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,591 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,617 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
826 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
255 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,217 reads
Blogs
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Forums
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Using Heaps
Comments posted to this topic are about the item Using Heaps
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers