Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,589 reads
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,589 reads
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,395 reads
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
638 reads
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
661 reads
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,046 reads
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
634 reads
Recently I posted about an interview with Jimmy Wales and only a couple days after that I ran across What...
2007-12-06
588 reads
Saw this on the Association for Computer Machinery SIGMOD announcements.
Tribute to Honor Jim Gray
It is scheduled for May 31, 2008...
2007-12-05
552 reads
Information week had an interesting article that talks about the different methods of licensing used, ranging from the what we're...
2007-12-04
646 reads
Ran across the Impactica Showmate, a $249 item (gadget?) that allows you to present Powerpoint presentations wirelessly via Bluetooth directly...
2007-12-04
648 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
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...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
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