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
PracticalSQLDba
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,970 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,226 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,614 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,161 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,048 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,807 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,597 reads
Blogs
What’s New at AWS re:Invent 2025 – Day 1 Highlights
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Forums
Adding a Lot of Seconds
Comments posted to this topic are about the item Adding a Lot of Seconds
SQL Server Licensing is Simple
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Stairway to Azure SQL Hyperscale Level 5: Data Growth and Fast Auto-Grow Mechanism
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Adding a Lot of Seconds
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers