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,686 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,959 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,612 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,225 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,158 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,604 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,554 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,047 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,805 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,579 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers