Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,209 reads
Matthew McGiffen DBA
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
409 reads
SQL Puzzle 3: Knights and Queens
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2019-04-26 (first published: 2017-08-22)
2,328 reads
Automatic Sample Sizes for Statistics Updates
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2019-04-26 (first published: 2017-08-15)
1,486 reads
How to be a bad interviewer
In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...
2017-08-08
1,421 reads
Manually updating Statistics
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,430 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2019-04-26 (first published: 2017-07-25)
7,584 reads
SQL Server Agent and Daylight Saving time
There was a bit of chat today on the SQL Community slack about UTC and Daylight Saving Time. It reminded...
2019-04-26 (first published: 2017-07-19)
2,545 reads
SQL Puzzle 2: Eight Queens
This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned...
2019-04-26 (first published: 2017-07-19)
2,199 reads
Think twice before using table variables
T-SQL Tuesday
For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way:
http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/
My...
2019-04-26 (first published: 2017-07-11)
8,986 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
BCA KCU DARMO No.telp:08385883375
Whatsapp:08385883375 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers