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 Plaza Index Telpon/wa:0813.7887.595.Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan,...
Jl. Raya Pajajaran No.5 & 6, RT.008/RW.09, Bantarjati, Kec. Bogor Utara, Kota Bogor, Jawa...
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