Speaking about Indexing
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is...
2010-02-08
346 reads
Blog Posts
T-SQL Speed Phreakery Explained
If you haven't seen the Simple-Talk newsletter (it's free, so sign up!) you may not have seen my article on...
2010-02-08
1,267 reads
Evolving Backups
I saw a post recently from my fellow Red Gate-er, Brad McGeHee, on backups. Brad’s got a ton of experience...
2010-02-07
427 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
1,785 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
547 reads
Some Initial Insert Test Benchmarks on SQL Server 2008 R2
They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been...
2010-02-07
4,338 reads
SQL Server Storage
This is a short post on SQL Server storage best practice and what i have learned over the years… Much...
2010-02-07
1,340 reads
SQL Server Waits and Queues
Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
The word document (880kb) can...
2010-02-07
589 reads
A New Season (A Networking Success Story)
I’d like to share a networking success story. Last year, I blogged about my experience at the PASS Summit of...
2010-02-05
1,182 reads
Another free tool for SQL Server...
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,130 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