No announcements
-
0 VotesIn memory full text search and constraints to file based tables
Does anybody have an idea or solution for the fact that it can be useful having a full text search based on a in memory table. It is from my position mandatory to have constraints ...Unanswered | 1 Replies | 29 Views | Created by mjeh1 - Wednesday, December 06, 2017 3:21 PM | Last reply by NedOtter - Wednesday, December 06, 2017 6:47 PM
-
0 Votes
InMemory tables
What are the general guidelines when trying to identify the tables that can be upgraded to In-Memory for better performance? I have an existing database from from which I am trying ...Answered | 9 Replies | 221 Views | Created by Satheesh Variath - Tuesday, November 28, 2017 6:16 AM | Last reply by Satheesh Variath - Thursday, November 30, 2017 4:09 AM -
0 Votes
I cannot restore a db along with "in memory-oltp filegroup"
Hi there, I am trying to restore a database created in sql2k14 on a sql2k16 edition: Let me know if ...Answered | 2 Replies | 42 Views | Created by Enric Vives - Wednesday, November 29, 2017 8:54 AM | Last reply by Enric Vives - Wednesday, November 29, 2017 10:00 AM -
0 Votes
column store miscellaneous
Hi, we run 2016 enterprise. I'm contemplating a snowflake whose dims do not use column store but whose fact table does in a non clustered fashion. And moving to a more de normalized format if column ...Answered | 17 Replies | 251 Views | Created by db042190 - Thursday, November 09, 2017 8:40 PM | Last reply by db042190 - Wednesday, November 22, 2017 8:01 PM -
0 Votes
There is insufficient system memory in resource pool 'default' to run this query - memory optimized tables - SQL Server 2016
We are using memory optimized tables and have estimated approx 124 GB will be used by the memory optimized tables. This allows for 20% growth of tables. ...Unanswered | 11 Replies | 1625 Views | Created by holen1master - Friday, April 28, 2017 9:48 PM | Last reply by jacroberts - Sunday, November 19, 2017 2:25 AM -
0 Votes
Column Store Index tuple mover not moving from closed to compressed
Hi, We are using SQL Server 2016 sp1 and evaluating ColumnStore Indexes for 2 tables but notice that status is not changing from "closed" to "compressed" in ...Unanswered | 16 Replies | 517 Views | Created by Harvinder76 - Tuesday, October 03, 2017 3:36 PM | Last reply by Neugebauer - Thursday, November 16, 2017 11:18 AM -
0 Votes
partitioning full column store table
Hi we run 2016 enterprise. I'm thinking about the trade off of compression in a full column data store vs just in a non clustered column store index on a row store table. The papers suggest the first ... -
0 Votes
Cannot migrate tables to OLTP in any databases running in a SQL instance \TEST
SQL 2016 - 13.0.4451.0. When trying to migrate a table to OLTP from any db (even a new one created for testing purposes) I am getting: Create failed for Table ...Answered | 2 Replies | 84 Views | Created by Jerome Boyer - Friday, October 27, 2017 5:11 PM | Last reply by Jerome Boyer - Friday, October 27, 2017 9:54 PM -
0 Votes
LocalDB- attempt to create MEMORY_OPTIMIZED type causes "Cannot continue the execution because the session is in the kill state."
sqllocaldb v Microsoft SQL Server 2017 (14.0.1000.169) Steps to reproduce: 1) create database 2) run ...Answered | 1 Replies | 128 Views | Created by SWheaties - Sunday, October 22, 2017 3:02 PM | Last reply by Erland Sommarskog - Sunday, October 22, 2017 6:16 PM -
1 Votes
in-memory tables do not release memory
I am running Enterprise SQL Server 2016 SP1 CU2. I have noticed that the unused space for both data and indexes was not being released. The numbers were (coming from the memory usage by Memory ...Unanswered | 5 Replies | 287 Views | Created by holen1master - Thursday, October 05, 2017 6:44 PM | Last reply by Tom Phillips - Monday, October 09, 2017 6:30 PM -
0 Votes
Change primary key of memory optimized table
Hi guys, Is is possible to change the primary key of memory optimized tables, without copying the data out, dropping and recreating the table with the new PK, and them moving the ...Answered | 2 Replies | 171 Views | Created by ToreS - Saturday, October 07, 2017 10:55 PM | Last reply by ToreS - Sunday, October 08, 2017 12:36 PM -
0 Votes
SQL server 2012 standard and 2014 standard memory issue.
we have bunch of SQL 2012 standard and SQL 2014 standard database instance running on windows 2012, each have different storage and memory. we are getting "Error Code: 802; There is insufficient ... -
0 Votes
2016 clustered columnstore & auto created statistics
Can someone explain the deal with clustered columnstore tables and the auto created statistics (_WA_sys_***) in 2016? i recall there was a performance issue in ...Unanswered | 3 Replies | 524 Views | Created by jakubk - Thursday, June 29, 2017 6:46 AM | Last reply by Andreas.Wolter - Thursday, September 14, 2017 9:31 PM -
0 Votes
How to free Ram
Hi Experts, i have a server whith in that, a single DB and a single table. I am running an Etl to insert data into a ...Answered | 10 Replies | 283 Views | Created by DileepReddyAchhala - Tuesday, September 05, 2017 8:21 AM | Last reply by DileepReddyAchhala - Tuesday, September 05, 2017 10:42 AM -
0 Votes
Columnstore Index Scan Affecting Performance
I have setup a columnstore index on a table which is used in a query that runs on the DW. Query runs on a SQL 2008 instance while and the single table which is the largest and is referenced using ...Unanswered | 8 Replies | 338 Views | Created by AK120684 - Thursday, August 17, 2017 10:22 AM | Last reply by Erland Sommarskog - Tuesday, August 22, 2017 9:49 PM -
6 Votes
In Memory Tables
We persist our user session data in a table in SQL server. On average we have between 30 000 to 40 000 rows of data in the table. It only tracks the unique ID for the session and an XML fragment that ...Proposed | 5 Replies | 419 Views | Created by swt1974 - Monday, August 21, 2017 2:50 PM | Last reply by swt1974 - Tuesday, August 22, 2017 12:46 PM -
0 Votes
in-memory oltp - "An XTP checkpoint operation encountered an error" ... no idea why, though
We encountered a major db issue yesterday and were really stumped by it. We're on Microsoft SQL Server 2016 (SP1-CU1) (KB3208177) - ...Unanswered | 5 Replies | 661 Views | Created by Niels Kruse (cut-e) - Friday, August 04, 2017 8:42 AM | Last reply by NedOtter - Sunday, August 20, 2017 10:12 PM -
0 Votes
Optimized file group deletion
Hi, As we have SQL 2016 E.Ed and for performance issues we had created the memory optimized table so with that optimized file group was created inbuilt in our database. After some ...Proposed | 6 Replies | 534 Views | Created by SUBHASH_DBA - Wednesday, July 19, 2017 10:45 AM | Last reply by TiborK - Monday, August 14, 2017 11:35 AM -
1 Votes
DELETE and Native Compiled SP
I have 3 tables that are to be DELETED based on the Input parameter (a table data type) How do i Perform DELETE Operation , since BREAK is not supported ? Please ...Answered | 6 Replies | 372 Views | Created by Vish_SQL - Thursday, August 03, 2017 7:43 PM | Last reply by Erland Sommarskog - Thursday, August 03, 2017 9:28 PM -
0 Votes
In-Memory SQL Server 2016 error
Hi, I am trying to get our ASP Session State database loaded in-memory on SQL Server 2016. I have read much documentation on doing this and utilized the recently released NuGet package with a ... - Items 1 to 20 of 166 Next ›
No announcements
