PracticalSQLDba

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,688 reads

SQL Server: Part1 : All About SQL Server Statistics :Density Vector

by nelsonaloor

PracticalSQLDba

In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...

2013-06-25

11,021 reads

SQL Server : Index at a glance

by nelsonaloor

PracticalSQLDba

In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...

2013-04-16

1,242 reads

SQL Server : Part 10: Importance of Key Column Position While Creating Index

by nelsonaloor

PracticalSQLDba

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,623 reads

Discuss

SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt

by nelsonaloor

PracticalSQLDba

Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...

2013-04-08

6,178 reads

SQL Server : Part 8 : Explaining The Covering Index or Included Columns

by nelsonaloor

PracticalSQLDba

In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index...

2013-03-25

2,614 reads

SQL Server : Part 7 : Non clustered index on non unique column

by nelsonaloor

PracticalSQLDba

In our earlier post, we have discussed about the non clustered index, but there we were always discussing about unique...

2013-03-24

3,563 reads

SQL Server : Part 6 : Design consideration of Clustered Index

by nelsonaloor

PracticalSQLDba

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,066 reads

SQL Server : Part 5 : Explaining Non clustered Index on Heap

by nelsonaloor

PracticalSQLDba

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,817 reads

SQL Server : Part 4 :Explaining the Non Clustered Index Structure

by nelsonaloor

PracticalSQLDba

A table can have only one clustered index as the data rows are stored in the order of the clustered...

2013-03-14

30,620 reads

PracticalSQLDba

SQL Server: Identifying Edition Specifc features Used in a Database

SQL Server: Part1 : All About SQL Server Statistics :Density Vector

SQL Server : Index at a glance

SQL Server : Part 10: Importance of Key Column Position While Creating Index

SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt

SQL Server : Part 8 : Explaining The Covering Index or Included Columns

SQL Server : Part 7 : Non clustered index on non unique column

SQL Server : Part 6 : Design consideration of Clustered Index

SQL Server : Part 5 : Explaining Non clustered Index on Heap

SQL Server : Part 4 :Explaining the Non Clustered Index Structure

Blogs

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

Rambling about Data on Wheels – origins, branding, expansion

Think Twice Before Enabling Fabric’s Inbound Network Protection

Forums

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

SQL Agent Job Automated Change Capture Process

Question of the Day

Finding a Database Master Key