Columnstore Indexes in SQL Server 2012

The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore indexes certainly do that effectively, they are not a universal panacea since there are a number of limitations on them. When used appropriately, they can reduce disk I/O and use memory more efficiently.

Columnstore index

Getting Started with the New Column Store Index of SQL Server 2012

Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index.

Columnstore Indexs

Columnstore Indexes for Fast DW

The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...

Column-Store Databases and DW Appliances

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.

RE: DTS Import from XLS question

Have you thought of changing the TrunkGroupID column to use identity? If you are just incrementing based on the existing columns max value then using the identity property of that column should solve the problem.

RE: Insert the results of a stored procedure into a table

This thread is 14 months old ... chances are they have the answer by now

RE: Creating Views: Changing column names

Dennis, try this:IF EXISTS (SELECT TABLE_NAME     FROM   INFORMATION_SCHEMA.VIEWS     WHERE  TABLE_NAME = N'Spain_Orders')     DROP VIEW Spain_Orders GOCREATE VIEW Spain_Orders AS  SELECT  [Order ID],  [Customer],  [Employee],  [Order Date],  [Required Date],  [Shipped Date],  [Ship Via],  [Freight],  [Ship Name],  [Ship Address],  [Ship City],  [Ship Region],  [Ship Postal Code],  [Ship Country] as [DestinationSpain]  FROM Orders  WHERE [Ship […]

RE: trobbels pasting text in a field

Have you tried a datatype of "text"?

Question of the Day for 20 Mar 2005

Comments posted to this topic are about the Question of the Day for 20 Mar 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=464.