No announcements
Found 2264237 threads
-
0 VotesQuery Failure | Merges on Index generated with Number.RandomBetween
about 4 lines above is causing the issue - and that Power Query is having trouble performing any merges on columns that have been previously calculated using the ...Answered | 2 Replies | 373 Views | Created by Jake Burns - Wednesday, January 2, 2019 5:41 PM | Last reply by Ehren - MSFT - Friday, January 11, 2019 12:17 AM
-
0 Votes
Query with index?
Hi, I have a table, when I execute query I want to display an index of retrieved records. Assume table has data ...Answered | 1 Replies | 5892 Views | Created by MNour.AI - Tuesday, February 20, 2007 12:01 PM | Last reply by Kent Waldrop _ - Tuesday, February 20, 2007 6:47 PM -
0 Votes
Query on Index Rebuild
Finally I manage to execute index rebuild command successfully using below syntax. ALTER INDEX ALL ON MetadataSchema.Entity REBUILD ...Answered | 11 Replies | 924 Views | Created by PraveenKumar_1999 - Wednesday, September 21, 2016 11:14 AM | Last reply by Olaf Helper - Wednesday, September 21, 2016 1:54 PM -
0 Votes
Query on Index
correct. Unlike the old network databases or filesystems, such computations are pretty cheap today. If you do a lot of reporting on the order date, then think about an ordered ...Answered | 5 Replies | 628 Views | Created by PraveenKumar_1999 - Wednesday, May 18, 2016 1:29 PM | Last reply by --CELKO-- - Friday, May 20, 2016 3:17 AM -
0 Votes
Generated query
Start a trace on Analysis Services using the Profiler (assuming that you are using Analysis Services 2005). Then you will be able to see the MDX queries generated by the cube ...Answered | 2 Replies | 7528 Views | Created by Thom_ - Tuesday, March 7, 2006 12:37 PM | Last reply by Thom_ - Tuesday, March 7, 2006 1:33 PM -
0 Votes
right index on below query
clustered only with include columns. is creating only non clustered index gives any problem. some body is saying don't create clustered index on date ...Answered | 4 Replies | 493 Views | Created by sivaramasqlserver - Thursday, May 14, 2015 12:25 PM | Last reply by sivaramasqlserver - Friday, May 22, 2015 9:30 AM -
1 Votes
SQL Server Agent Job, Reorg Index - Failure on disabled index
) Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) I have come across an SQL Server Agent Job that ...Answered | 1 Replies | 3338 Views | Created by Jeelani Kamal - Wednesday, November 30, 2011 5:38 PM | Last reply by Jonathan Kehayias - Wednesday, November 30, 2011 6:07 PM -
0 Votes
Bad request generated with table.ExecuteQuery(query)
think. For example, you can refer this thread: httpAnswered | 6 Replies | 3964 Views | Created by Schnauzer1 - Tuesday, December 25, 2012 8:14 PM | Last reply by Schnauzer1 - Friday, December 28, 2012 11:36 PM -
0 Votes
Index on query with both where clause and order by
Do you actually need all of the columns to be returned in the SELECT statement? Depending on the answer to that, you may be able to use a "covering index", that covers the ...Unanswered | 2 Replies | 6227 Views | Created by rpsu - Sunday, February 25, 2007 9:30 AM | Last reply by Glenn A. Berry - Sunday, February 25, 2007 3:14 PM -
0 Votes
SQL query generated.
Hi, Is there any way to look at behind-the-scene SQL query that gets generated by SSRS engine to pull the data out of the data source (particularlyUnanswered | 2 Replies | 3985 Views | Created by Uzzie - Friday, May 2, 2008 12:41 AM | Last reply by Uzzie - Friday, May 2, 2008 9:35 AM -
0 Votes
SSIS and SMO Generated CREATE INDEX Statements
Is there a way to use SSIS and generate CREATE INDEX statements for a table? I would like to create a separate file for each index on a list of specified tables -- is there ... -
0 Votes
Query not use Index
http://www.sommarskog.se/dyn-search.html There are several things going on with your different versions of the query and why ...Answered | 1 Replies | 5943 Views | Created by Kostas M - Wednesday, April 18, 2007 6:06 PM | Last reply by Kent Waldrop _ - Wednesday, April 18, 2007 6:27 PM -
0 Votes
Query performance on partitioned table with partitioned-index
Hi all, I noticed that there are some big query performance difference when using partitioned-index on partitioned table vs. normal index ...Unanswered | 6 Replies | 8761 Views | Created by OracleDBA - Wednesday, February 14, 2007 5:57 PM | Last reply by OracleDBA - Friday, February 23, 2007 7:32 PM -
0 Votes
DataTable with primary key merges equal values
Hi. I have an application that should read from database or a xls file to a data table with primary keys. Sometimes when i merge the new loaded data with ...Unanswered | 1 Replies | 10472 Views | Created by andrerm - Monday, August 18, 2008 6:37 PM | Last reply by Michael Sun [MSFT] - Thursday, August 21, 2008 8:02 AM -
1 Votes
Index Rebuild Failure - ARITHABORT
I have been experiencing failures with rebuilding indexes. If the database has Arithabort ON it works, if not, it fails. Does anyone now why? The ...Answered | 2 Replies | 4609 Views | Created by Patrick Grant - Tuesday, March 2, 2010 2:03 PM | Last reply by Patrick Grant - Wednesday, March 3, 2010 11:38 AM -
0 Votes
Create Index on inner join query
given the inner join query below, trying to come out with the index for better performance, does the index has any prob? select a.fSrvMemBillNo, ...Answered | 5 Replies | 8414 Views | Created by learner08 - Wednesday, February 15, 2012 2:49 AM | Last reply by Uri Dimant - Wednesday, February 15, 2012 9:41 AM -
3 Votes
Query on Index Key and Unique Key
INDEX IX_Table_2 ON dbo.MyTable ( COLUMN1, COLUMN2 ) WITH( STATISTICS_NORECOMPUTE = OFFAnswered | 11 Replies | 6814 Views | Created by Sathyaprakash - Wednesday, May 18, 2011 8:04 PM | Last reply by Stan210 - Thursday, May 19, 2011 2:50 PM -
0 Votes
Query to rebuild index
Actually... STATISTICS_NORECOMPUTE does not control whether or not the recomputed happens, it only controls if the statistics are updated on the index. There's little reason to ...Answered | 6 Replies | 1565 Views | Created by winoa - Tuesday, June 3, 2014 1:41 PM | Last reply by Patrick Hurst - Wednesday, June 4, 2014 2:17 PM -
0 Votes
to amend query designer generated mdx query
This is working fine. Thanks! I have one question regards to this query. As we can see, when this query gets generated via query designer, then the block of ...Answered | 5 Replies | 2932 Views | Created by MKG2011 - Wednesday, October 19, 2011 2:48 PM | Last reply by Waco_Huber - Wednesday, October 19, 2011 7:55 PM -
0 Votes
Index Size query
clustered index and you have all the leaf data you need on the nonclustered. This cost on data size and also on its maintenance. So to make it ...Proposed | 5 Replies | 1120 Views | Created by johnrp88 - Monday, May 4, 2020 7:16 PM | Last reply by Cris Zhan - Friday, May 22, 2020 2:31 AM - Items 1 to 20 of 2264237 Next ›
No announcements
