No announcements
-
0 VotesQuestions about timing queries
Hi all (and especially the dev team), I've been having an interesting discussion with Colin Banfield in the comments section of a blog post I wrote some time ago ...Answered | 6 Replies | 788 Views | Created by Christopher Webb - Wednesday, March 9, 2016 4:17 PM | Last reply by Colin Banfield - Sunday, March 13, 2016 6:16 PM
-
5 Votes
How common are interval intersection (overlap) queries? short 5-question survey
Hi all, I’m in a discussion with Microsoft about adding features to the SQL Server engine that can improve the performance of interval intersection/overlap ...Discussion | 3 Replies | 1932 Views | Created by Itzik Ben-Gan - Monday, March 4, 2013 6:02 PM | Last reply by Naomi N - Wednesday, March 13, 2013 8:45 PM -
0 Votes
Datasets in Report Parameter Execution Question
Dear Anyone, We have reports that has several report parameters which in turn, each uses 2 datasets that queries from the database. We have some performance concerns and ... -
0 Votes
Query Statistics History Report Duration and Execution Time taken
Hi everyone I have about 4 jobs calling the same stored procedure but each time it runs it executes different Id's. When Job1 is running it may takes 45 minutes ...Unanswered | 2 Replies | 3530 Views | Created by Sarah2005 - Thursday, June 13, 2013 4:28 PM | Last reply by Sarah2005 - Friday, June 14, 2013 7:38 AM -
0 Votes
Query question
I have a question about doing a specific type of query. I have built a database for a manager in which he will track employees and errors commited while performing their ...Answered | 2 Replies | 5340 Views | Created by jimbo101974 - Tuesday, May 1, 2007 6:05 PM | Last reply by Arnie Rowland - Tuesday, May 1, 2007 6:51 PM -
0 Votes
Query Editor misbehaves
, e.g. complaining about undeclared variables that are properly declared. Closing and reopening the query resolves the issues. I also have a ... -
0 Votes
hi all , small help about Stored Procedure !
the answer was to prevent sql query from running many times , and we should use it in caseAnswered | 2 Replies | 4970 Views | Created by greaso - Monday, July 27, 2009 9:30 PM | Last reply by greaso - Tuesday, July 28, 2009 12:07 PM -
0 Votes
Query Timeout and Get All Rows Message
Hi all. I have two questions about Proclarity. First: In my actual project whe have a Procaltiry - Report that takes more than 3 ...Unanswered | 1 Replies | 6214 Views | Created by Christian Montenegro - Thursday, November 25, 2010 11:26 AM | Last reply by S Kumar Dubey - Monday, November 10, 2014 12:52 AM -
0 Votes
Dynamic query
numberd, use a CASE expression to pick the columns. The question I have is why do this? If all columns are only useful one at a time, this is ...Answered | 5 Replies | 6848 Views | Created by xyzt - Sunday, September 17, 2006 3:58 PM | Last reply by xyzt - Monday, September 18, 2006 9:29 AM -
0 Votes
Prediction Query for a "weighted" clustering model
I have a question about writing a prediction query against a clustering model that has the same column added more than once. Per Jamie, I can ...Answered | 1 Replies | 7163 Views | Created by DanMeyers - Tuesday, December 12, 2006 12:07 AM | Last reply by Jamie MacLennan - Tuesday, December 12, 2006 4:13 PM -
0 Votes
Query for ExecutionLogStorage for reports not used in the past 30 days
I wrote a similar question in the SSRS forum as well. Maybe someone here might have some idea about this questions. I ...Answered | 2 Replies | 1012 Views | Created by bonusmarch - Wednesday, April 24, 2013 9:51 PM | Last reply by Allen Li - MSFT - Friday, April 26, 2013 2:34 AM -
0 Votes
Make remote query faster?
So we are expected to answer questions about tables we have no knowledge and tell you why its slow? If I am to make a guess completely out of the blue, my guess is ...Answered | 1 Replies | 349 Views | Created by maca128 - Monday, September 19, 2016 10:21 AM | Last reply by Erland Sommarskog - Monday, September 19, 2016 11:16 AM -
0 Votes
Little question about ü,ö,ä and other special signs
Hello everyybody! ive got a little question. but couldnt found anything about it ( well im short on time too) working on win 7 ...Answered | 2 Replies | 3518 Views | Created by HH.Scripting - Thursday, May 5, 2011 1:53 PM | Last reply by HH.Scripting - Wednesday, May 11, 2011 6:29 AM -
0 Votes
SSRS Exception while executing an MDX Query
ReportExecutionService SOAP endpoint. The part that puzzles me here, and maybe this is a better question for the SSAS forum (I'll go there next if no one here ...Answered | 1 Replies | 5325 Views | Created by Carl Daniel - Thursday, March 19, 2009 11:17 PM | Last reply by Carl Daniel - Thursday, March 19, 2009 11:44 PM -
0 Votes
WebDAV Query generates a high number of transaction log files
for contacts on an Exchange 2007 server. The number of contacts returned for each user's mailbox is quite high (about 4500). I've noticed that each time the WebDAV ...Discussion | 0 Replies | 4993 Views | Created by Alexandre Defalque - Thursday, January 22, 2009 10:12 AM -
0 Votes
Slow opening of cube SQL Analysis
Wow, now that's an open ended question. So, a number of questions: How long is too long? What version of Analysis Services? (2000/2005/2008?) Are we ...Answered | 1 Replies | 6551 Views | Created by nethanjavier - Friday, August 6, 2010 3:04 AM | Last reply by Philip Stephenson - Friday, August 6, 2010 12:46 PM -
0 Votes
OAuth's auth digest times out within a minute of obtaining it on calls to the search rest webservice.
in a load balanced scenario that we send the rest call to. On one server, this works fine time over time - the user can continuously query SharePoint ...Unanswered | 1 Replies | 331 Views | Created by Bill Richardson IFGW - Thursday, April 14, 2016 11:04 PM | Last reply by Victoria Xia - Friday, April 15, 2016 9:19 AM -
0 Votes
Question on partitions on cubes
Hi,all experts here, Thank you very much for your kind attention. I am having quesions about the partitions on cube. Will the partitions actually improve ... -
0 Votes
Intermittent "The current operation timed-out after 15 seconds" Errors
; Digging into the ULS, I see that the logs shows the following message immediately after the 15 seconds: "Query router timed out after waiting for substrate ...Answered | 2 Replies | 5807 Views | Created by Wedge A - Wednesday, March 2, 2016 7:46 PM | Last reply by Jithendar Bathini - Monday, October 9, 2017 9:18 AM -
0 Votes
Windows 2008 R2 DNS services, 'Restricting queries in a particular zone'
I have a question about security on Windows 2008r2 DNS services. Currently we have single forest, single domain configuration. 2 ad integrated ...Answered | 1 Replies | 1673 Views | Created by the_borgqueen - Wednesday, October 24, 2012 3:57 PM | Last reply by Ace Fekay [MCT] - Wednesday, October 24, 2012 5:08 PM - Items 1 to 20 of 1603131 Next ›
No announcements
