you’re trying to build a ColumnStore Index and Increased the DOP or using multiple columns on the Index and you did received this error message

“cannot start the columnstore index build because it requires at least 760040 KB, while the maximum memory grant is limited to KB per query in workload group 'default'”

Well don’t decrease your Columns. Simply it’s a Resource Governor modification “even if it’s not enabled” as the default workgroup is created by default with 25% of Memory per Query…!!!

1. Go To Resource Governor under Management

2. enable it and change the default workgroup in the memory granted to 100

3. try building again the index it’ll succeed

SQL Server 2012 introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a broad range of queries fitting the scenario for which it was designed.

enough with the talk let’s have a quick view on it in this Video

yes it’s, it’s the Sequence that you can use as a number generator separated from Columns and tables. it’s a new Object added to SQL 2012 ANSI Standard. to be used in many situations. I can remember now that it would made my life easier if I had it before. let’s have a look on the implementation

1. we’ll create a new sequence with T-SQL

CREATE SEQUENCE [dbo].[S2] 
 START WITH 200
 INCREMENT BY 20
 GO

Or from the GUI under <DATABASE NAME>programmatically/sequences

2. to get the next Value for it simply type (Next Value For S2)

select (next value for s2)

so a simple table with two columns (ID bigint, TheText varchar(5) )

insert into test1(thetext) 
values ( next value for s2, 'Text1')

or even put the default binding for the ID Column to be (Next Value For s2 )

I can’t even think if the options. one thing I needed before is to update a table with an Auto Number. now you can do it without a loop.

So Welcome Sequence to to T-SQL Family

It’s the time for Open door… Monday and Tuesday in Cairo Heliopolis Fairmont Hotel in Egypt we’re having our annually Open Door even with first day for IT Professionals and second day for Developers. I have a session with Hisham Mortada Monday 12:00 PM for What’s New in SQL Server 2012.

Amr Al Asway will be delivering a session regarding what's new in System Center 2012. and Tuesday Ayman El-Hattab will be having a session Software Development Lifecycle with Microsoft Visual Studio.

Cumulative Update 5 contains hotfixes for the Microsoft SQL Server 2008 R2 issues that have been fixed since the release of SQL Server 2008 R2.

in the middle of the celebrating our new version of SQL Server that will come in the Launch event 1 week from now we need not to forget about the amazing SQL Server 2008 R2 with the CU 5 for some fixes

here’s more details about it

http://support.microsoft.com/kb/2438347