Database jokes
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,235 reads
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,235 reads
The idea for this script came at times when I was having a project that needed to use snapshots of databases...
2014-05-09
108 reads
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
101 reads
Here are some places on the web where you can find sample databases for SQL Server. It's nice to have...
2014-02-27
1,413 reads
Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...
2014-02-24
222 reads
This is my blog. Here, I’d like to say "Hello" and wish myself many posts. I’ll be mainly posting about...
2014-02-15
148 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers