Web Site Tuning
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
604 reads
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
604 reads
I read Life and Death on the World’s Most Dangerous Mountain by Ed Viesturs ($18 @ Amazon) over the holiday break....
2010-01-22
737 reads
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
538 reads
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,190 reads
Recently I caught a few minutes of a CSPAN interview with Chief Justice John Roberts, part of a larger presentation...
2010-01-20
490 reads
Somehow had completely missed this one, The Architectural Journal is published quarterly in PDF format. Issue 22 seems to be...
2010-01-20
542 reads
I’ve been thinking a lot lately about how to be more effective at collaborating, usually in the context of a...
2010-01-19
680 reads
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
2010-01-19
155 reads
Before you dig in this post, take a look at my earlier notes about oPASS and Live Meeting and the...
2010-01-18
761 reads
I read a lot and like to think my interests are wide, but I fall into ruts all the same....
2010-01-15
530 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...
Telp/wa 085169998803 Jl. MT. Haryono No.337, Jagalan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
Harco Mangga Dua Plaza, Jl. Mangga Dua Raya Blok F/1, Mangga Dua Sel., Kecamatan...
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
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