No announcements
Found 3254205 threads
-
0 VotesSQL Server: SP become very slow, raw SQL query from the SP is still very fast
The solution is ...Answered | 2 Replies | 4609 Views | Created by Dimic - Tuesday, June 3, 2014 1:21 PM | Last reply by Naomi N - Tuesday, June 3, 2014 4:43 PM
-
2 Votes
SP excuting very slow
The message indicates that SQL Server needed to expand the tempdb database, but was unable to, because your disk was full.Answered | 3 Replies | 2506 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
first time that runs a sp is very slow
i need it, becouse on monday for example, in my users shows an error (time expires) and i have to run the sp in sql management to fix it, but i can't do it all mondays, or whenever ...Answered | 7 Replies | 2688 Views | Created by Jiordie - Wednesday, December 21, 2011 3:43 PM | Last reply by Jiordie - Wednesday, December 21, 2011 8:33 PM -
7 Votes
SSRS report running very slow but query is very fast in SSMS
I ended up deleting groups/tables from the report and rerunning until it was fast.Answered | 15 Replies | 123749 Views | Created by kesar_k - Wednesday, April 3, 2013 3:00 AM | Last reply by AaronLST - Thursday, January 30, 2020 3:10 PM -
3 Votes
SQL Azure very slow
Answered | 16 Replies | 6501 Views | Created by brvaland - Friday, December 5, 2014 10:34 AM | Last reply by Igor Kondrasovas - Monday, December 29, 2014 10:54 AM -
0 Votes
sql server become slow
All applications are subject to performance constraints because of resource, design, or usage factors as use of the application increases and the size of your database ...Answered | 2 Replies | 5130 Views | Created by ahmadiza - Tuesday, October 23, 2012 11:30 AM | Last reply by peterdru - Wednesday, November 7, 2012 6:04 AM -
0 Votes
SP & JOB performing very slow
HOW ...Answered | 3 Replies | 5476 Views | Created by subu999 - Thursday, March 17, 2011 1:49 PM | Last reply by Fabrizzio Caputo - Thursday, March 17, 2011 2:44 PM -
0 Votes
sql server become slow
sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CCEQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F4%2F7%2Fa%2F47a548b9-249e-484c-abd7-29f31282b04d%2FTShoo ...Answered | 2 Replies | 2319 Views | Created by ahmadiza - Tuesday, October 23, 2012 1:24 PM | Last reply by Sarabpreet Singh Anand - Tuesday, October 23, 2012 3:36 PM -
2 Votes
Very slow SQL query
1 if possible, create a index on the email, address and nation column to speed it up.Answered | 10 Replies | 5615 Views | Created by IanExpanz - Tuesday, September 13, 2011 4:25 AM | Last reply by ameyjoe - Tuesday, December 18, 2012 7:36 AM -
1 Votes
ROBOCOPY very very slow in SQL Server Job
Moreover even if it use VSS, We have to make sure the SQL Writer service ("SQL Server VSS Writer") is on, which is installed with SQL ...Answered | 11 Replies | 3577 Views | Created by zcurtin608 - Tuesday, November 12, 2013 5:16 AM | Last reply by dave bianco - Tuesday, November 12, 2013 9:23 PM -
0 Votes
Query execution is very slow
but problem is that when i run this query in vb.net the result has been slow more from qeury run in sql server ...Answered | 4 Replies | 985 Views | Created by haqayyum - Sunday, May 8, 2016 7:03 PM | Last reply by Dan Guzman - Tuesday, May 10, 2016 12:04 PM -
0 Votes
SP slow from app fast from SSMS.
I guess they are still a single statement, but the SPs typically have a dozen or more of these, and I hate tracking down the issues one statement at a time.Answered | 6 Replies | 4077 Views | Created by JRStern - Friday, March 1, 2013 7:53 PM | Last reply by Tom Phillips - Tuesday, April 9, 2013 3:15 PM -
4 Votes
Use SP or SQL Query
Thanks Eric, So in this scenario, it make sense to shift the SQL to SSIS instead of SP?Answered | 7 Replies | 867 Views | Created by Neilcse - Monday, February 15, 2016 3:57 AM | Last reply by Harry Bal - Tuesday, February 16, 2016 8:13 PM -
0 Votes
SQL SERVER 2008 VIEW RUNNING VERY SLOW
But sql server is still picking the bad execution plan and taking too much time to complete the query.Answered | 10 Replies | 5705 Views | Created by Momen Azmath - Friday, April 19, 2013 11:29 AM | Last reply by Momen Azmath - Tuesday, October 22, 2013 11:22 AM -
0 Votes
SQL SP calling another SQL SP
Hello Amit, In SQL Server / T-SQL everything is executed sequentially & syncron, so your control flow in SP1 will wait until the execution of SP2 is ...Answered | 3 Replies | 2081 Views | Created by Amit Srivastava - Monday, April 29, 2013 2:33 PM | Last reply by Rahul Kumar (Rahul Vairagi) - Monday, April 29, 2013 6:52 PM -
0 Votes
Page Viewer WebPart loads very slow in SP 2013
https://social.technet.microsoft.com/Forums/office/en-US/93ecef0b-93be-4083-8ed4-6dd471643b8d/sharepoint-2013-very-slow-page-load-times?Answered | 2 Replies | 974 Views | Created by Sandeep.Handa - Wednesday, February 17, 2016 5:36 PM | Last reply by Lakshmanan Sethu - Wednesday, February 17, 2016 6:32 PM -
0 Votes
SQL Query Insert Very Slow After Windows Update
All fast SQL 2008 performance in initial install.Answered | 5 Replies | 3793 Views | Created by afif ahmad - Monday, June 12, 2017 1:00 PM | Last reply by huuugirl - Friday, May 3, 2019 1:58 PM -
0 Votes
Very slow Search query
SQL Server compile it but I got any result on the exection.Answered | 3 Replies | 3608 Views | Created by Link.fr - Monday, July 5, 2010 5:12 PM | Last reply by Link.fr - Tuesday, July 6, 2010 8:13 PM -
4 Votes
Accessing sql server from lan is very slow.
Hi Glenn, As you said i tested. i ran a batch file to create view using sqlcmd.exe but could not create view and hitting error: 'Unable to complete login process ...Answered | 6 Replies | 3593 Views | Created by Tariq Iftikhar - Monday, January 14, 2013 7:11 PM | Last reply by - Wednesday, January 16, 2013 9:44 PM -
2 Votes
The Query in SQL Server 2019 is Very Slow
What they do in SQL 2019 is that they attempt to inline scalar functions into the query (this is not always possible, though).Answered | 3 Replies | 3443 Views | Created by RUoyun - Wednesday, March 18, 2020 2:28 AM | Last reply by RUoyun - Thursday, March 19, 2020 2:05 AM - Items 1 to 20 of 3254205 Next ›
No announcements
