No announcements
Found 3070476 threads
-
0 VotesSP slow from app fast from SSMS.
In this app they put a fair amount of business logic (I guess we can call it) into the SPs.Answered | 6 Replies | 4127 Views | Created by JRStern - Friday, March 1, 2013 7:53 PM | Last reply by Tom Phillips - Tuesday, April 9, 2013 3:15 PM
-
0 Votes
Runs fast from SSMS slow from SSRS
If so, this issue may resulted from “Parameter Sniff”.Answered | 4 Replies | 2715 Views | Created by anaylor01 - Wednesday, September 21, 2016 7:16 PM | Last reply by anaylor01 - Thursday, September 22, 2016 4:19 PM -
0 Votes
SQL Server: SP become very slow, raw SQL query from the SP is still very fast
The solution is ...Answered | 2 Replies | 4676 Views | Created by Dimic - Tuesday, June 3, 2014 1:21 PM | Last reply by Naomi N - Tuesday, June 3, 2014 4:43 PM -
0 Votes
Cube is fast in SSMS and slow in Excel
But the strange things are: Without VisualTotals makes no difference (exact the same time) On my machine (I've made a .abf file) the SSMS cube ...Answered | 4 Replies | 4785 Views | Created by MikeHendriks14 - Thursday, August 18, 2011 1:52 PM | Last reply by MiKeHendriks - Monday, August 22, 2011 2:26 PM -
1 Votes
Simple "planned relocation" upgrade from SP 2007 to SP 2010 question...
You can ignore this content database. just go-ahead and remove this content database from sharepoint 2010 server and delete the wss_content from the new sql ...Answered | 2 Replies | 8579 Views | Created by ETJAB - Tuesday, October 19, 2010 8:54 PM | Last reply by ETJAB - Thursday, October 28, 2010 3:43 AM -
1 Votes
when a SP plan goes bad ?!
So, when the SP is first compiled, it "sniffs" the values and chooses a plan.Answered | 5 Replies | 1439 Views | Created by Ranga1 - Monday, May 19, 2014 6:07 PM | Last reply by JRStern - Tuesday, May 20, 2014 10:22 PM -
0 Votes
Migrate From SP 2010 to SP 2013 vs SP 2016
You can also checkout this informative article which summarizes few nice tips while preparing to move towards SharePoint ...Answered | 4 Replies | 1994 Views | Created by junidev - Tuesday, October 18, 2016 7:20 PM | Last reply by michaelsymondson - Wednesday, October 19, 2016 7:47 AM -
0 Votes
Weird problem with SP
Also i have another SP which will update the table is also taking too(10mis) long but when I execute the query in the SP as a sql statement it's ...Answered | 5 Replies | 2148 Views | Created by guest369 - Wednesday, August 29, 2012 10:06 PM | Last reply by Dan Guzman - Friday, August 31, 2012 3:08 AM -
0 Votes
Upgrade to SP 2010 from SP 3.0
There are also many schema and other functionality changes to make upgrading from 2003 directly to 2010 simple.Answered | 7 Replies | 4005 Views | Created by yugi.p - Wednesday, June 13, 2012 12:39 PM | Last reply by Steven Andrews - Thursday, June 14, 2012 12:37 PM -
0 Votes
SP executing sometimes fast, sometimes slow.
I see parallelism in the execution plan and wait type CXPACKET; that could be the reason; add*OPTION (MAXDOP 1)* query hint ...Answered | 6 Replies | 1610 Views | Created by maca128 - Friday, July 15, 2016 12:20 PM | Last reply by Kartar Rana - Saturday, July 16, 2016 5:31 AM -
2 Votes
SP excuting very slow
http://www.sommarskog.se/query-plan-mysteries.html If you want more direct help, please post the procedure code as well as the SQL you actually run.Answered | 3 Replies | 2660 Views | Created by vikas kumar pathak - Monday, March 18, 2013 9:10 AM | Last reply by Gert-Jan Strik - Monday, March 18, 2013 8:52 PM -
0 Votes
SP duration is longer from .Net as compare to running directly from SSMS.
Hopefully, the article may also help you address the problem.Answered | 12 Replies | 2471 Views | Created by Asam, Muhammad - Wednesday, June 19, 2013 2:44 PM | Last reply by Erland Sommarskog - Monday, June 24, 2013 8:08 AM -
0 Votes
Migrate From SP 2010 to SP 2013 - Diferent Domain
Operations -> Perform a Backup and backup entire farm.Answered | 3 Replies | 1101 Views | Created by junidev - Thursday, October 20, 2016 10:20 AM | Last reply by Wendy DZ - Friday, October 21, 2016 8:52 AM -
0 Votes
stored procedure runs slow in reporting services, fast in SSMS
Hi, I read about parameter sniffing, I made the change but there was no improvement; I made other kind of test and found other issues: the report executes sp ...Answered | 7 Replies | 10599 Views | Created by Edgar López - Wednesday, June 26, 2013 9:42 PM | Last reply by - Friday, January 29, 2016 2:07 AM -
1 Votes
SharePoint 2013 - Migrate Access Apps from SP 2013 to SP 2016
If so, you could save the list as template in SharePoint 2013, upload the template to SharePoint 2016 and create the list from the template.Answered | 1 Replies | 927 Views | Created by Tom Molskow - Thursday, November 8, 2018 6:20 PM | Last reply by Sara Fan - Friday, November 9, 2018 3:55 AM -
1 Votes
SP and ad-hoc plans differ
Different SET options can affect the reuse of query plans.Answered | 16 Replies | 4261 Views | Created by Leon Mayne - Tuesday, March 2, 2010 10:55 AM | Last reply by Plamen Ratchev - Tuesday, March 2, 2010 4:20 PM -
1 Votes
Table Valued Function running slow when called from SP
Maybe I will put that code into a separate SP and execute that SP from the main SP.Answered | 11 Replies | 5978 Views | Created by AndreiPetrut - Thursday, May 2, 2013 8:52 AM | Last reply by AndreiPetrut - Friday, May 3, 2013 7:21 AM -
0 Votes
Stored procedure runs fast sometimes and slow the others.
Since he is not getting deadlocks, the trace flags are entirely irrelevant.Answered | 10 Replies | 1346 Views | Created by Ian Wrigglesworth - Thursday, May 2, 2019 1:46 PM | Last reply by Ian Wrigglesworth - Wednesday, May 8, 2019 10:56 AM -
1 Votes
SSMS detection of SP/Function default parameter values
The queries you showed refer to SQL Server 2005+ catalog views, while I am using SSMS to connect to an SQL Server 2000 instance, so I don't think that SSMS uses those views in my ...Answered | 2 Replies | 6562 Views | Created by Melsen Asllani - Tuesday, April 26, 2011 12:31 PM | Last reply by Melsen Asllani - Wednesday, April 27, 2011 12:53 PM -
1 Votes
SP executed around 6 mins in Execute SQL Task but still executing from past 30 mins in SSMS.
That SP is executed around 7 mins in SSIS.Answered | 10 Replies | 4221 Views | Created by guest369 - Thursday, July 19, 2012 9:15 PM | Last reply by Vinaya Ravi - Thursday, July 26, 2012 3:34 AM - Items 1 to 20 of 3070476 Next ›
No announcements
