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,675 reads
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,675 reads
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
10,508 reads
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,584 reads
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,218 reads
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...
2013-04-08
6,100 reads
In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index...
2013-03-25
2,572 reads
In our earlier post, we have discussed about the non clustered index, but there we were always discussing about unique...
2013-03-24
3,522 reads
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,024 reads
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,777 reads
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,268 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers