Tag: denali
-
Steps to configure SQL server Availability Groups in DENALI
In this blog post I will drive you through configurations steps required (with GUI screens) to successfully implement SQL server’s new high availability option called “ALWAYSON” aka HADR . If you haven’t read more about Always ON or Availability groups in SQL server code named “Denali” version, here are some articles that I would recommend…
-
ColumnStore Index
What’s this? Columnstore index is a new type of index available from the future release of SQL Server known as Denali aka SQL Server 2011. Columnstore index helps data warehouse queries to execute faster than the normal indexes.This index is suited if the volume of data is high and same type of query is used…
-
New SSMS GUI Changes in SQL Server 2011 (Denali)
Im just writing this article to provide you the new changes to SSMS GUI available in SQL Server 2011 aka Denali. This article is not more into techie however it will just visualize you the changes made to SSMS GUI in .SQL 2011 Ill update this article whenever I see a new change in SSMS…
-
Adding Startup parameter made easy in Denali
You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a…
-
SEQUENCE – Feature in Denali
Another long-waited feature SEQUENCE is included in the latest version of SQL server code named DENALI. Sequence is now an object in each database and is similar to IDENTITY in functionality. Sequence is an object that has start value, increment value and end value defined in them and this sequence can be added to a…