I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.

SQL Server: Identifying Edition Specifc features Used in a Database

by nelsonaloor

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,681 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

10,875 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,608 reads

Discuss

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

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,149 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,596 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,550 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,044 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,803 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,526 reads

Blogs

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Secure Azure SQL Server Backups Using Managed Identities

I do believe most people know about the ability to backup your SQL server...

Read the latest Blogs

Forums

Just a rant about the SQL Server 2022 upgrade

Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...

Report Server Configuration Manager - The target principal name is incorrect SSL

SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...

Report Server Configuration Manager - Change Database - SSL Error

SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers