No announcements
Found 3275244 threads
-
0 VotesSSRS taking a long time to run an MDX query
Hi, I have an MDX query which runs fine in the MDX Sample Application.Answered | 4 Replies | 4802 Views | Created by Suman Sarkar - Thursday, October 7, 2010 9:14 AM | Last reply by VisaAde - Thursday, October 7, 2010 4:40 PM
-
0 Votes
Simple query taking so long time to run
Hi, According to your description, you need to know why your simple query taking so long time to run, right?Answered | 13 Replies | 1030 Views | Created by Database Junior - Monday, January 19, 2015 8:56 PM | Last reply by Charlie Liao - Monday, January 26, 2015 5:53 AM -
0 Votes
Query taking long to run....not sure why?!
2) Take out those NOLOCK.Answered | 5 Replies | 819 Views | Created by buchay2019 - Monday, October 5, 2015 7:42 PM | Last reply by Erland Sommarskog - Monday, October 5, 2015 10:14 PM -
1 Votes
C# - linq query taking long time to runs
ToList "just" forces the query to run and return a result into a List.Answered | 4 Replies | 3560 Views | Created by AdityaReddyM - Friday, February 20, 2015 8:45 PM | Last reply by Andy ONeill - Saturday, February 21, 2015 9:51 AM -
2 Votes
SQL Query Tuning - Query takes long time
Why did you think this was how to write SQL??Answered | 9 Replies | 1500 Views | Created by vj78 - Wednesday, April 10, 2013 6:49 PM | Last reply by --CELKO-- - Wednesday, April 10, 2013 9:01 PM -
0 Votes
SELECT query takes a long time
when you select all columns and all records, your indexes are not engaged with plan. maybe you can take a look at your application design and change your query ...Answered | 8 Replies | 7858 Views | Created by JasonHuang8888 - Tuesday, October 18, 2011 2:49 AM | Last reply by Dan Guzman - Tuesday, October 18, 2011 12:09 PM -
0 Votes
MDX query taking a long time
the way OLAP processes this, is does 22 distinct selects against the big table. each one of those selects takes 1 hour in my case, so that was not an ...Answered | 3 Replies | 4285 Views | Created by squarewave24 - Monday, December 5, 2011 10:17 PM | Last reply by rok1 - Tuesday, December 6, 2011 3:55 PM -
2 Votes
SSIS Package takes a long time to run
So my initial thought is to look at the actual query itself.Answered | 8 Replies | 6742 Views | Created by teahou - Tuesday, July 28, 2015 3:57 PM | Last reply by teahou - Monday, August 3, 2015 5:54 PM -
0 Votes
Sql Server Query taking long time to execute
2.Are there Blocking was exists 3.Are there any resources issues you had like CPU,MEMORY,I/O when query was running.Answered | 4 Replies | 4358 Views | Created by Shon24 - Thursday, September 15, 2016 12:36 AM | Last reply by Shanky_621 - Friday, September 16, 2016 5:17 AM -
0 Votes
Stored procedure Taking long time
The following article deals with query and system optimization: http://www.sqlusa.com/articles/query-optimization/ In a stored procedure, each ...Answered | 3 Replies | 6998 Views | Created by suresht - Thursday, March 29, 2012 12:20 AM | Last reply by arun.passioniway - Thursday, March 29, 2012 8:04 AM -
1 Votes
sys.dm_db_index_physical_stats taking a very long time
When i query the sys.dm_db_index_physical_stats DMV for the first time, it takes about 30 minutes.Answered | 6 Replies | 10397 Views | Created by Bortiquai - Friday, March 16, 2012 7:34 PM | Last reply by JRStern - Tuesday, March 20, 2012 5:04 PM -
1 Votes
Taking database offline takes long time...
Run sp_who2 while your command is executing to see if you're being blocked by another process.Answered | 5 Replies | 2179 Views | Created by Veena Srinivas - Monday, June 15, 2020 8:57 PM | Last reply by TiborK - Tuesday, June 16, 2020 8:23 AM -
0 Votes
Procedure takes a long time in a job step, but not when running in a query window
For the reason why there can be different query plans, it can be cache plan, parameter sniffing, or other facts.Answered | 5 Replies | 2400 Views | Created by DerekCall - Monday, January 23, 2012 5:41 PM | Last reply by Kalman Toth - Monday, January 30, 2012 6:56 AM -
4 Votes
tablediff takes very long time to execute
So yes, that could be why it is taking so long.Answered | 6 Replies | 8165 Views | Created by Bojan Skrchevski - Tuesday, October 4, 2011 3:29 PM | Last reply by Brandon Williams - Wednesday, October 5, 2011 9:52 PM -
0 Votes
update stats taking long time
updating statistics on large table can take a long time and for larger tables it can be better to use a sample percentage.Answered | 2 Replies | 1963 Views | Created by Man-Of-Steel - Wednesday, April 20, 2016 2:44 PM | Last reply by GuruArthur - Thursday, April 21, 2016 9:06 AM -
1 Votes
Query with multiple subqueries - takes a long long time to run
Naomi, your query still takes 8 minutes to run (rather than over 16 minutes before the index changes).Answered | 13 Replies | 5406 Views | Created by HuelvaD - Friday, November 4, 2011 11:47 AM | Last reply by HuelvaD - Friday, November 4, 2011 4:02 PM -
2 Votes
Database shrink takes long time
Maybe doing some kind of reorg of the LOB data first would help ... then again maybe ...Answered | 14 Replies | 18375 Views | Created by Phillip_Morris - Wednesday, September 28, 2016 12:57 PM | Last reply by JRStern - Thursday, September 29, 2016 5:12 PM -
0 Votes
Why is the ResolveProjectReferences taking a really long time?
Hi Irfspy, If you want to reduce ResolveProjectReferences time, you need to Reduce Dependencies, since the task can search dependencies to the "nth-order", ...Answered | 2 Replies | 1767 Views | Created by Irfspy - Thursday, August 4, 2016 9:08 AM | Last reply by Irfspy - Monday, August 8, 2016 3:52 PM -
0 Votes
Report Rendering taking long time
SSRS Tabular Report is taking too much time to render.Answered | 8 Replies | 1627 Views | Created by PMunshi - Tuesday, February 9, 2016 6:23 PM | Last reply by Qiuyun Yu - Wednesday, February 24, 2016 9:23 AM -
1 Votes
Pre-Execute Taking a Long Time
I use queries.Answered | 14 Replies | 2970 Views | Created by Tom Moreau - Wednesday, April 11, 2012 12:53 PM | Last reply by Tom Moreau - Wednesday, April 11, 2012 4:10 PM - Items 1 to 20 of 3275244 Next ›
No announcements
