Reading Time: 15 minutes (it is quite hard going, but you need to know this if you need to work with the DacFx)
DacFx - Getting the data type of...
2019-04-17
31 reads
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of ... Continue reading
2019-04-17 (first published: 2019-04-03)
355 reads
I am very proud to announce that I have been selected to present an exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called...
2019-04-17
19 reads
One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...
2019-04-17 (first published: 2019-04-03)
726 reads
A while back I learned that it’s possible to create temporary stored procedures in SQL Server. I never put that knowledge into practice however because I struggled to think of...
2019-04-16 (first published: 2019-04-02)
862 reads
(2019-Apr-02) Last week Microsoft introduced a new Validation activity task to the Azure Data Factory (ADF) - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-validation-activity Initially, I was confused by its name, thinking that it would help me...
2019-04-16 (first published: 2019-04-03)
11,137 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
10 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
10 reads
Got this email from a client in the southern US asking how to up their game in SQL Server, frustrated by a lack of hands-on opportunities to administer SQL...
2019-04-15
22 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62 Lt.l Ruang...
Jl. Yos Sudarso No. 50, RT 009 RW 02. Kel. Melayu, Pasiran, Kec. Singkawang...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers