I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
5 reads
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
310 reads
Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...
2016-03-01
1,547 reads
I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...
2016-03-01
110 reads
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,121 reads
A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
Related Posts:
An Experiment with Deadlocks March...
2016-03-01
40 reads
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
661 reads
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
458 reads
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was almost a blog I didn't write because I...
2016-02-29
3 reads
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was...
2016-02-29
976 reads
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
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