Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,697 reads
Kendal Van Dyke
Meme Monday
Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...
2011-04-04
397 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
393 reads
Has Microsoft Desktop Virtualization Reached The End Of The Road?
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
611 reads
STS-134 Rollout
If you follow me on Twitter or talk to me in person you'll come to realize I'm a space enthusiast....
2011-03-15
514 reads
MagicPASS March 2011 Meeting Notice
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
483 reads
I've Got A New Job
You've probably noticed I've been quiet on this blog lately, eeking out a post every other week on average. I've...
2011-02-24
1,523 reads
How Can I Help You Go To SQLRally?
I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...
2011-02-23
404 reads
MagicPASS February 2011 Meeting
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
535 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
715 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Question of the Day
Creating a JSON Document II
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