SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
681 reads
Blog Posts
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
6 reads
SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features
sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:
- Compression,
- Partitioning,
- TDE and...
2011-08-22
1,366 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
761 reads
T-SQL to find Fragmented Indexes
Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...
2011-08-22
7,517 reads
Why You Should Attend SQL Saturday 97
Reposted from :http://sqlaj.wordpress.com/2011/08/19/why-you-should-attend-sql-saturday-97/
By AJ Mendo
Free Training
Part of the mission statement of SQL Saturday (read the full statement here) is to...
2011-08-22
919 reads
Chance to win a free seat in my Performance Troubleshooting Workshop in London!
As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting
Workshop" from September 12 – 14 in Central London. You...
2011-08-21
965 reads
Pull Performance Data from Perfmon Logs with PowerShell
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,408 reads
What Will Be New for Reporting Services in 2012?
Drum roll, please! We’re in the throws of refreshing the Wrox Professional Series book on Reporting Services and, as we...
2011-08-21
1,273 reads
ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,970 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
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
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCP Urip Sumoharjo TLP/,WA 08216977749
Jl. Jend. Urip Sumoharjo No.133, Kepatihan Wetan, Kec. Jebres, Kota Surakarta, Jawa Tengah 57129
BCA KCP Tebet Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet...
BCA KCP Purwosari TLP/WA 08216977749
Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta, Jawa...
Question of the Day
Creating a JSON Document III
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