No announcements
Found 24 threads
-
0 VotesHow to insert data into memory optimized table?
I'm trying to insert data from a non-in-memory table into a memory-table via a simple: insert into Contract_Zone_Loss select Contract_ID, Zone_ID, Year, Day, ...
-
0 Votes
Server Memory Performance
When two application's users were connected with database server and there was no other on going traffic the SQL is using 6.7 GB of memory. How ever we have checked when all users are ...Unanswered | 1 Replies | 1927 Views | Created by nortec - Saturday, June 28, 2014 4:04 PM | Last reply by AV111 - Tuesday, May 5, 2015 3:29 PM -
0 Votes
Best alternative for rowversion
We're currently evaluating SQL Server 2014's In-Memory OLTP for our application and saw in the documentation that rowversion is not a supported ...Unanswered | 5 Replies | 3749 Views | Created by Mathias Seidl - Wednesday, September 4, 2013 4:48 PM | Last reply by Israel Valdez - Wednesday, February 25, 2015 10:57 PM -
0 Votes
Clustured ColumnStore Index in memory ?
Hello Friends, I am a BI Specialist and have some experience with analysis service in memory columnstore technology.As far as i know sql 2014 and sql tabular ... -
0 Votes
In-Memory OLTP
When I right click a table in my sql server azure database and select "Memory Optimization Advisor" I get a "Operation not supported on version 11.0.9216 SqlAzureDatabase" error. ...Unanswered | 1 Replies | 1831 Views | Created by jbentonsc - Monday, August 18, 2014 4:41 PM | Last reply by Ahsan Kabir - Thursday, August 21, 2014 6:53 AM -
0 Votes
Batch query that access (via join) both Memory Optimized table and regular Disk Based Table
Hi, I can't find an answer to this question: If I send a batch query (not a natively compiled stored procedure) to SQL Server 2014 that performs a join between ...Unanswered | 3 Replies | 1826 Views | Created by VladiV - Monday, July 28, 2014 9:08 AM | Last reply by Bob Beauchemin - Tuesday, August 5, 2014 9:13 PM -
0 Votes
Too many checkpoint file pairs in SQL Server 2014 CTP2
Hi, i am wondering what is the best way to remove extra checkpoint file pairs. let me explain. i have the following ...Unanswered | 3 Replies | 2560 Views | Created by Ben Dippenaar - Monday, February 10, 2014 12:31 AM | Last reply by Sunil Agarwal - Monday, July 28, 2014 4:59 PM -
0 Votes
How does in-memory sql server 2014 comapares with others in the market.
I was working on SAP Hana and next project is on sql server 2014. I have started doing self study. Would be great if someone can enlighten on how sql server 2014 in-memory ... -
0 Votes
Server Memory Usage Issue
When two application's users were connected with database server and there was no other on going traffic the SQL is using 6.7 GB of memory. How ever we have checked when all users are ... -
0 Votes
Search on String Columns Without Case Sensitivity
Hi all, I want to create in-memory table and have varchar column with index so that I can search it. But seems I must use BIN collation and therefore this column will behave case ...Unanswered | 1 Replies | 1900 Views | Created by Leila S - Tuesday, June 3, 2014 9:51 AM | Last reply by Jos de Bruijn [MSFT] - Wednesday, June 18, 2014 3:39 PM -
0 Votes
Creating an in-memory table using SELECT...INTO
Is it possible to create a memory optimized table using SELECT INTO option.. If yes, can someone help me with the syntax. I have already tried out the following but none of them ...Unanswered | 1 Replies | 2506 Views | Created by pb.85 - Wednesday, June 18, 2014 12:34 PM | Last reply by Jos de Bruijn [MSFT] - Wednesday, June 18, 2014 3:31 PM -
1 Votes
Managing memory optimized and disk based table
Hi, I want to use memory optimized table with both feature (memory & disk). For this, I am using DURABILITY = SCHEMA_AND_DATA in my create table script. This will ...Unanswered | 10 Replies | 2151 Views | Created by Deepak_Goyal - Wednesday, March 26, 2014 11:55 AM | Last reply by Jos de Bruijn [MSFT] - Wednesday, June 18, 2014 12:07 AM -
0 Votes
no column information for data collection
Hi all, I'm trying to run table usage & stored proc usage data collection on a Server 2008 R2 box with a view to migrating to SQL2014. I have set up a management data warehouse ... -
0 Votes
In-Memory user defined table, not in memory?
Hi I am using SQL Server 2014 CTP2, with READ_COMMITTED_SNAPSHOT ON (I think it's important for the question). I have create an In-Memory table type (very ...Unanswered | 2 Replies | 1890 Views | Created by Avishai.M - Thursday, January 30, 2014 9:43 AM | Last reply by Bob Beauchemin - Sunday, February 2, 2014 7:35 PM -
0 Votes
I need a TSQL alternative to NOT EXISTS(), EXCEPT, MERGE, or a LEFT JOIN
I am trying to insert data into a table INSERT INTO dbo.AlgorithmData_mo SELECT ToEdge, 2147483647.0 dist, -1 pred, 1 inqueue FROM ...Answered | 24 Replies | 5587 Views | Created by danholmes - Thursday, January 9, 2014 3:44 PM | Last reply by danholmes - Friday, January 10, 2014 2:32 PM -
0 Votes
Are you using In-Memory OLTP in SQL Server 2014?
Just wondering, are you using it? If not, why? If you are using it, how is it going? David Schwartz [MSFT] This posting is provided "AS IS" with no warranties, ...Unanswered | 1 Replies | 2095 Views | Created by David Two Sheds - Thursday, July 11, 2013 11:44 PM | Last reply by danholmes - Thursday, January 9, 2014 9:50 PM -
1 Votes
[SQL Server 2014 CTP2]Collation limitation on memory optimized tables
When I was trying to create a memory optimized table in the database with collation "Chinese_Simplified_Stroke_Order_100_CI_AS", I got an error message as ...Unanswered | 2 Replies | 3883 Views | Created by JianHuang - Monday, December 23, 2013 8:07 AM | Last reply by Jos de Bruijn [MSFT] - Monday, December 30, 2013 10:23 PM -
0 Votes
Implementation of ordinary CLUSTERED indexes (not HASH) as in-memory tables in 2014
We are considering 2014 (CTP1) to launch a performance critical financial system. In this work, we are considering SQL 2014 in-memory features and are currently running CTP1. We ...Unanswered | 3 Replies | 2266 Views | Created by Kristian Lough-Grimsgaard - Monday, November 4, 2013 9:24 AM | Last reply by Jos de Bruijn [MSFT] - Thursday, November 28, 2013 12:52 AM -
0 Votes
Will CLR UDT's be supported for in-memory tables in the final release?
We have custom user-defined types (UDT) with a size of varbinary(max) and would like to know if the SQL team are planning to allow this for in-memory tables before the final ...Unanswered | 2 Replies | 2153 Views | Created by andrieso - Wednesday, November 6, 2013 7:00 AM | Last reply by Kevin Farlee [MSFT] - Wednesday, November 27, 2013 8:12 PM -
0 Votes
Maximum physical memory InMemory OLTP supports
Hi, according to http://blogs.technet.com/b/dataplatforminsider/archive/2013/08/01/hardware-considerations-for-in-memory-oltp-in-sql-server-2014.aspx "You can have a ...Unanswered | 2 Replies | 2334 Views | Created by Dimaa - Tuesday, November 12, 2013 5:11 AM | Last reply by Sunil Agarwal - Tuesday, November 12, 2013 6:06 PM - Items 1 to 20 of 24 Next ›
No announcements
