Can You Compress a Temp Table?
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,515 reads
Blog Posts
I Just Voted in the PASS 2013 Election
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
575 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
738 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
369 reads
PASS Votes
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
751 reads
Performance Tuning In LA!
Hello Dear Reader! This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta. Due to...
2013-09-26
531 reads
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,222 reads
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,354 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,583 reads
Which personal traits should a #SQLPASS Director have?
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,089 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers