Cleaning up sys.dm_exec_cached_plans
Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...
2010-01-27
1,124 reads
Blog Posts
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,431 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
992 reads
Identity Values – Dropouts and Spaces
Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...
2010-01-27
996 reads
Lenovo W510
I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510,...
2010-01-27
937 reads
Speaking at the Baltimore SQL Server User Group
On Monday, the first of February, 2010, I will be speaking at the Baltimore SQL Server User Group meeting at...
2010-01-27
488 reads
SQL Saturday #34
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
590 reads
Wildcards in WHERE Clauses
This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the...
2010-01-27
591 reads
Another Keyboard Down
I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a...
2010-01-26
906 reads
Database Normalization
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,809 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers