No announcements
-
Unanswered0VotesEngine behaviour changed
I have a 12 core server, Windows2008R2 Datacentre with SQLServer 2014 12.0.2000 Enterprise. When using a completely vanilla installation, the engine will not ...3 Replies | 163 Views | Created by Philip Lewis - Friday, April 04, 2014 2:20 PM | Last reply by Jay Choe - Tuesday, May 06, 2014 8:13 PM
-
Unanswered0Votes
MAYBE A BUG IN SQL2014. I DEPLOY THE CLR TO DB .
MAYBE A BUG IN SQL2014. I DEPLOY THE CLR TO DB IN SQL2014 I MEET A ERROR " COULD NOT CONNECT TO TARGET SERVER ...2 Replies | 87 Views | Created by CHENHUNHUN - Sunday, April 06, 2014 1:05 PM | Last reply by Dan Woodhouse - Thursday, May 01, 2014 1:24 PM -
Unanswered0Votes
Creating linked servers on SQL Server 2008 R2 instances that point to SQL Server 2014
This is likely a dumb question, but is it possible to create linked servers on a SQL Server 2008 R2 instance that point to a SQL Server 2014 instance?3 Replies | 99 Views | Created by Northwester - Tuesday, April 08, 2014 5:22 PM | Last reply by Rick Byham, Microsoft - Tuesday, April 22, 2014 3:51 PM -
Unanswered0Votes
Is SQL Server 2014 database compatiable with Dynamics GP 2010?
Hi, We have a plan to upgrade SQL server from 2008 R2 to 2014 in quarter 3. I am using SQL server 2008 R2 for Dynamics GP 2010. Is SQL server ...1 Replies | 70 Views | Created by Calsoft 888 - Saturday, April 12, 2014 4:24 AM | Last reply by Sunil Agarwal (SQL) - Tuesday, April 15, 2014 4:55 PM -
Answered0Votes
Polybase
Hi, is there any Polybase integration in SQL 2014? Or is that somethign we only will see on PDW? Thanks... Thomas Pagel2 Replies | 216 Views | Created by Thomas Pagel - Thursday, December 12, 2013 11:49 AM | Last reply by Artin Avanes (MSFT) - Thursday, March 27, 2014 8:57 PM -
Answered1Votes
rebuilding clustered columnstore index
If i'm inserting into a clustered columnstore index each hour, do I have to rebuild the index each hour as well so the new data gets indexed? Or does it automatically get indexed when inserting like ...5 Replies | 241 Views | Created by rpatel18 - Saturday, December 14, 2013 4:52 PM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:20 AM -
Unanswered0Votes
100% cpu usage when querying on clusteredcolumn store indexed table.
I have a table in sql 2014 ctp2 that is 148 million rows and about 450 columns wide. I created a clustered column store index on it and it appears that each time my cpus get maxed out at ...5 Replies | 249 Views | Created by rpatel18 - Saturday, December 28, 2013 4:18 AM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:14 AM -
Unanswered0Votes
Does Microsoft plan to add primary key and unique constraints to clustered columnstore index in next releases of SQL Server after 2014?
Clustered columnstore index is a greate feature in SQL Server 2014, but currently cannot be used with primary key and unique constraints, which is important to achieve data integrity. I wonder if ...4 Replies | 429 Views | Created by xiagao - Saturday, January 11, 2014 6:09 AM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:05 AM -
Unanswered0Votes
Clustered vs nonclustred columnstore read performance
I have been looking into performance characteristics of clustered columnstore indexes in SQL 2014 Enterprise CPT2. Our data warehouse is currently on SQL 2012 with columnstore indexes in ...1 Replies | 153 Views | Created by Eagle_Dude - Tuesday, February 25, 2014 5:56 PM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:01 AM -
Answered5Votes
Can I limit max size to memory-optimized table ?
Can I limit max size to memory-optimized table ? I want to use memory-optimized tables in many tables/databases. For example, a memory-optimized table limit 10GB ...7 Replies | 457 Views | Created by Yoshihiro Kawababata - Sunday, March 23, 2014 1:27 PM | Last reply by Sunil Agarwal (SQL) - Tuesday, March 25, 2014 4:51 PM -
Proposed1Votes
Can I reserve system memory for an ERROR '[SQL Server]There is insufficient system memory in resource pool 'default' to run this query.' ?
Can I reserve system memory for an ERROR '[SQL Server]There is insufficient system memory in resource pool 'default' to run this query.' ? I want to use 'MEMORY_OPTIMIZED = ...1 Replies | 209 Views | Created by Yoshihiro Kawababata - Friday, March 21, 2014 11:41 PM | Last reply by Jos de Bruijn - Monday, March 24, 2014 5:24 PM -
Answered2Votes
SQL Server 2014 release date and version number
Currently we are with the CTP1 release of SQL14 and the version number is 11. Do I take then the SQL2014 CTP1 as part of SQL2012? is the version number 11 will be the final number of ...5 Replies | 2913 Views | Created by AndresGC - Wednesday, July 24, 2013 4:24 PM | Last reply by wBob - Monday, March 24, 2014 10:59 AM -
Unanswered0Votes
SQL Server 2014 CTP2 taking time for the query
Hi, Before telling my problem, let you know that I am migrating my database to Microsoft SQL Server 2014 (for the moment ...6 Replies | 274 Views | Created by Mazhar Nazeer - Thursday, January 09, 2014 9:56 AM | Last reply by wBob - Saturday, March 22, 2014 4:42 AM -
Answered0Votes
Can I speed-up Delayed_Durability=FORCED database with 50 connection than DISABLED database ?
Can I speed-up Delayed_Durability=FORCED database with 50 connection than DISABLED database ? I want to know the reason why Delayed_Durability=FORCED database slow than DISABLED ...4 Replies | 195 Views | Created by Yoshihiro Kawababata - Wednesday, March 12, 2014 2:42 PM | Last reply by Yoshihiro Kawababata - Wednesday, March 19, 2014 2:04 AM -
Unanswered0Votes
Can I tune up Delayed Durability by AdventureWorks2012 by SQL Server 2014 CTP2 ?
Can I tune up Delayed Durability by AdventureWorks2012 by SQL Server 2014 CTP2 ? I am checking between Deleyed Durability = FORCED and = DISABLED by ...1 Replies | 170 Views | Created by Yoshihiro Kawababata - Wednesday, March 12, 2014 11:30 AM | Last reply by Jos de Bruijn - Friday, March 14, 2014 7:57 PM -
Unanswered0Votes
Can I speed-up TPC-H Query 9 for Clustered Columnstore Index used Database ?
Can I speed-up TPC-H Query 9 for Clustered Columnstore Index used Database ? I want to speed-up Query 9. I am tring TPC-H to SQL Server 2014 ...1 Replies | 180 Views | Created by Yoshihiro Kawababata - Saturday, March 01, 2014 4:39 PM | Last reply by Yoshihiro Kawababata - Wednesday, March 12, 2014 11:32 AM -
Unanswered0Votes
Module
Hi, I propose Microsoft to provide SQL module (PSM) for Transact SQL, similar to Oracle PL/SQL package. We can wrap procedures, functions, types, objects (constants and variables) in the module. It is ... -
Unanswered1Votes
Can I read TPC-H's table DDL by optimezed columnstore index on SQL Server 2014 ?
Can I read TPC-H's table DDL by columnstore index on SQL Server 2014 ? I want to find more effective SQL Server 2014's columnstore index. TPC-H's dbgen ...1 Replies | 184 Views | Created by Yoshihiro Kawababata - Tuesday, February 25, 2014 4:35 PM | Last reply by Tracy Cai - Wednesday, February 26, 2014 8:49 AM -
Answered1Votes
Missing documentation for the pre-release of SQL Server 2014
Hello, I have looked at the BOL about SQL Server 2014 and I have found some missing important information : - no list of depreciated features ...2 Replies | 171 Views | Created by Papy Normand - Friday, January 31, 2014 1:18 PM | Last reply by Papy Normand - Friday, January 31, 2014 10:14 PM -
Unanswered0Votes
Does SQL Server 2014 support Accelerator cards such as GPU, Phi ect. ??
We have a customer talking about SQL Server 2014 support of accelerator cards such as GPU. So wanted to know/enquire if GPU cards are supported with SQL 2014 ?? - Items 1 to 20 of 44 Next ›
No announcements
