SQL Server: Identifying Edition Specifc features Used in a Database
I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is...
2013-06-26
1,687 reads
SQL Server: Part1 : All About SQL Server Statistics :Density Vector
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
10,988 reads
SQL Server : Part 10: Importance of Key Column Position While Creating Index
Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...
2013-04-22 (first published: 2013-04-16)
6,618 reads
SQL Server : Index at a glance
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,229 reads
SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...
2013-04-08
6,166 reads
SQL Server : Part 8 : Explaining The Covering Index or Included Columns
In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index...
2013-03-25
2,606 reads
SQL Server : Part 7 : Non clustered index on non unique column
In our earlier post, we have discussed about the non clustered index, but there we were always discussing about unique...
2013-03-24
3,558 reads
SQL Server : Part 6 : Design consideration of Clustered Index
In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss...
2013-03-21
2,053 reads
SQL Server : Part 5 : Explaining Non clustered Index on Heap
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,811 reads
SQL Server : Part 4 :Explaining the Non Clustered Index Structure
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,606 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers