Statistics Update Clarification
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...
2013-01-11 (first published: 2013-01-07)
2,525 reads
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...
2013-01-11 (first published: 2013-01-07)
2,525 reads
I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written...
2013-01-09
895 reads
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,535 reads
Just a quick little blog post about one more app you’re going to want to track down for your Surface....
2012-12-12
956 reads
After living with the Surface for a month and trying hard to make it work as a tool for production,...
2012-12-06
1,756 reads
After multiple talks with Jason Strate (blog|twitter) and Denny Cherry (blog|twitter) about how they are working on automating more of...
2012-12-05
1,133 reads
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,381 reads
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,686 reads
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,928 reads
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
893 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...
BCA KCP Senen Telpon/wa:0813.7887.595.Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
Komplek Ruko, Jl. Veteran Utara No.9 Blok F No. 8, Lariang Bangi, Kec. Makassar,...
BCA KCU PANGERAN JAYAKARTA Telpon/wa:0813.7887.595.Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah...
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