No announcements
Found 633004 threads
-
1 Votesimproving query performance with columnar storage
Hi eb Would you attempt to improve classic star schema queries performance by simply migrating (or duplicating) underlying tables to ...Proposed | 4 Replies | 853 Views | Created by reapeleg - Saturday, June 15, 2019 6:11 PM | Last reply by Dedmon Dai - Thursday, June 20, 2019 9:54 AM
-
1 Votes
Improve SSAS query performance
Hi Jan, There're many ways which can improve the query performance, like creating Partitions, defining Aggregations, using cache, etc. It also depends on ...Unanswered | 2 Replies | 627 Views | Created by VinkieNL - Friday, September 16, 2016 1:15 PM | Last reply by Simon_Hou - Monday, September 19, 2016 8:32 AM -
0 Votes
columnar storage in Denali
Hi Josh, Column Store Indexes have been shown to improve query times by magnitudes of 100x + but for the wrong type of query it will decrease ...Answered | 4 Replies | 8402 Views | Created by JRStern - Tuesday, April 12, 2011 4:06 PM | Last reply by JRStern - Wednesday, April 13, 2011 5:38 PM -
0 Votes
How to Improve Query Performance
Hello, It is difficult to give you some tips to improve queries performance as we need some more information. For example ...Answered | 1 Replies | 1801 Views | Created by KA Kishore - Monday, April 1, 2013 7:20 PM | Last reply by Papy Normand - Monday, April 1, 2013 8:25 PM -
0 Votes
Performance with runing hive query
performance: Order of magnitude improvements to Hive query response times (up to 40x) and to data compression (up to 80%) using the Optimized Row Columnar ...Proposed | 4 Replies | 2274 Views | Created by shai ben ami - Tuesday, May 20, 2014 6:19 AM | Last reply by AmarpreetBassasn - Wednesday, September 16, 2015 10:55 AM -
0 Votes
Improving performance of query with View
but is there any better way to improve performance of query when accessed across databases. Thanks, Vishal.Answered | 2 Replies | 683 Views | Created by vishal.... _ - Tuesday, April 15, 2014 1:42 PM | Last reply by vishal.... _ - Tuesday, April 15, 2014 7:18 PM -
2 Votes
Improve Query Performance - Indexes
this, and also has the NOT IN rewritten to an EXISTS (which might also improve performance): Declare @ForbiddenCustomerIdentifier int Set ...Answered | 3 Replies | 828 Views | Created by obrienkev - Thursday, October 31, 2013 4:15 PM | Last reply by Gert-Jan Strik - Thursday, October 31, 2013 10:54 PM -
0 Votes
How to improve the performance of this query?
I have the sql query below. It takes 25 seconds to run. The PageViewLog table only has about 8000 records only. Is there anyway I could improve the performance of this ...Answered | 3 Replies | 3619 Views | Created by waterding - Wednesday, October 7, 2009 10:18 AM | Last reply by waterding - Wednesday, October 7, 2009 12:18 PM -
0 Votes
How to improve performance of query
I was given a query to look for performance.I have to improve the performance of that query. I looked into indexs on filtering columns,also ...Answered | 3 Replies | 3804 Views | Created by anki2010 - Wednesday, April 13, 2011 12:36 AM | Last reply by Gert-Jan Strik - Thursday, April 14, 2011 1:37 AM -
0 Votes
Improve OLAP Query Performance
Can any body let me know the various techniques to improve the OLAP query performanceAnswered | 1 Replies | 6343 Views | Created by Nagaraj Ennikapati - Tuesday, May 10, 2011 7:05 AM | Last reply by Marko Culo - Tuesday, May 10, 2011 7:51 AM -
0 Votes
Improve CrossTab query performance
speed improvement. Any one who has done queries speed performance and could share his/her experience is greatly appreciated. Thanks in ...Unanswered | 5 Replies | 3998 Views | Created by Ramzan Sadiq - Wednesday, July 16, 2008 9:54 PM | Last reply by Ramzan Sadiq - Thursday, July 17, 2008 12:47 PM -
2 Votes
Improve the query performance
Hi Nikkred, According to your description, you are joining 2 table which contain more than 50 million records. Now what you want is improving query ...Answered | 13 Replies | 1183 Views | Created by NikkRED - Sunday, August 24, 2014 3:26 PM | Last reply by Patrick Hurst - Tuesday, September 2, 2014 3:22 PM -
0 Votes
improve query performance
Improves MS SQL Database Performance SQL Server Integration Services:Answered | 11 Replies | 1049 Views | Created by hart60 - Sunday, November 4, 2018 10:28 AM | Last reply by - Tuesday, November 6, 2018 5:17 AM -
0 Votes
query performance improve
thanks , it helped but still need to improve the performance Any progress? Do you see something (bottleneck) in the execution plan? Optimization ...Proposed | 11 Replies | 1806 Views | Created by guymalka - Thursday, May 30, 2013 12:08 PM | Last reply by guymalka - Monday, August 26, 2013 10:52 AM -
0 Votes
Query performance improvement-2
SQL Gurus, Please share the thoughts/Ideas to improve the performance of this huge query aplogize for that .Thanks In AdvanceAnswered | 6 Replies | 3351 Views | Created by NimmiY - Saturday, September 24, 2011 6:11 AM | Last reply by Erland Sommarskog - Sunday, September 25, 2011 10:03 PM -
0 Votes
Improving performance of MDX queries
about MDX query performance Top 10 best practices and hits for your reference. Please see: http://technet.microsoft.com/en-usAnswered | 2 Replies | 1151 Views | Created by Bhadri1991 - Saturday, August 17, 2013 12:02 AM | Last reply by Elvis Long - Monday, August 19, 2013 7:15 AM -
0 Votes
Improve sqlce3.0 query performance
it is taking around 40sec depending on data. I have created index also. Can any one help regarding how to improve query ...Answered | 3 Replies | 6104 Views | Created by Ram A - Monday, October 26, 2009 6:55 PM | Last reply by ErikEJ - Tuesday, October 27, 2009 3:15 PM -
1 Votes
Improve SSRS Query Performance
Question: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/adaf0cb6-b9d9-4651-a7ef-d4e19020e6e0/improve-ssrs-query-performance ...Unanswered | 21 Replies | 1091 Views | Created by SQLBI19 - Tuesday, January 29, 2019 10:33 PM | Last reply by Soumen Barua - Tuesday, February 5, 2019 7:36 AM -
0 Votes
How to improve the query performance
is performance..it takes 10sec to retrieve for single project when i'm executing the sp. how can i create index on temp table in this sp and how can i improve the ...Unanswered | 5 Replies | 809 Views | Created by LuckyLucky12 - Wednesday, March 12, 2014 9:04 AM | Last reply by Visakh16 - Wednesday, March 12, 2014 9:51 AM -
3 Votes
Improve Query Performance
it is a massive GROUP BY query, it may not be easy to improve it. First question, is it business critical? If yes, then it is worth trying. Can you post table/index ...Answered | 8 Replies | 731 Views | Created by dct374 - Thursday, February 12, 2015 4:28 PM | Last reply by Aung Mon Chit Htwe - Friday, February 13, 2015 12:58 AM - Items 1 to 20 of 633004 Next ›
No announcements
