No announcements
Found 1547283 threads
-
0 VotesStored Procedure Running Issue
Our DB guys resolved the issue, by adding extra ram to the server and now my queries are running faster.Answered | 3 Replies | 784 Views | Created by NaveenCR - Wednesday, February 18, 2015 2:10 AM | Last reply by dave_gona - Wednesday, February 18, 2015 4:24 AM
-
0 Votes
Stored procedure Issue
SQL Server is not by default track when stored procedures were called.Answered | 1 Replies | 856 Views | Created by mito access - Thursday, August 7, 2014 3:49 PM | Last reply by Erland Sommarskog - Thursday, August 7, 2014 9:39 PM -
2 Votes
Stored procedure issue
Correction in your code: CREATE PROCEDURE dbo.usp_PurgeOldData ( @PurgeWaits SMALLINT ) AS BEGIN; IF @PurgeWaits IS ...Answered | 2 Replies | 552 Views | Created by subu999 - Tuesday, September 20, 2016 12:45 PM | Last reply by Naomi N - Tuesday, September 20, 2016 1:01 PM -
4 Votes
Stored Procedures Deadlock Issue
However each call to UpdateMain stored proc causes Deadlock when stored proc A and stored proc B are called simultaneously.Answered | 6 Replies | 6042 Views | Created by obrienkev - Wednesday, September 12, 2012 8:45 AM | Last reply by Dan Guzman - Thursday, September 13, 2012 10:15 AM -
6 Votes
Stored Procedure creation issue
Task 2 Now warp this logic to stored procedure sp_wrapper which takes input Product names separated by comma.Answered | 20 Replies | 1930 Views | Created by BHVS - Friday, June 27, 2014 10:04 AM | Last reply by Sofiya Li - Monday, July 7, 2014 5:57 AM -
1 Votes
Stored Procedure merge issue
I am no longer running each stored procedure from the other.Answered | 10 Replies | 5566 Views | Created by Matt11380 - Thursday, March 10, 2011 2:56 PM | Last reply by Matt11380 - Monday, March 14, 2011 2:34 PM -
0 Votes
Nested Stored Procedures performance issue
Is it possible to get the time each of the nested stored procedures took to complete?Answered | 6 Replies | 7679 Views | Created by all_user_names_taken_already - Monday, July 12, 2010 9:01 PM | Last reply by Tom Cooper - Saturday, January 14, 2012 4:38 PM -
1 Votes
Stored procedure executed in stored procedure
Hi IqPerf, You can also use OpenQuery to select data from a Stored Procedure.Answered | 4 Replies | 5217 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM -
0 Votes
Stored Procedure Issue
Where is the other half of the procedure?Answered | 3 Replies | 4805 Views | Created by Matt11380 - Wednesday, February 2, 2011 2:56 PM | Last reply by wBob - Wednesday, February 2, 2011 3:45 PM -
2 Votes
Sql Server stored procedure issue
We call a stored procedure to Sql Server 2008.Answered | 3 Replies | 829 Views | Created by Peter Campanale - Friday, July 22, 2016 2:35 PM | Last reply by Olaf Doschke - Monday, July 25, 2016 2:35 PM -
3 Votes
Difference between Stored Procedure and extended Stored Procedure
p=25288&seqNum=7 https://www.sqlconfiguration.com/enterprise-issues-business-rules/module5/system-extended-stored-procedures.php#gsc.tab=0Answered | 4 Replies | 1431 Views | Created by MU DBA - Wednesday, August 8, 2018 11:18 AM | Last reply by Erland Sommarskog - Wednesday, August 8, 2018 9:48 PM -
0 Votes
Calling a common Stored Procedure from multiple stored procedure performance issues
Moved because this isn't a database design question, but the problem you mention sounds (without any sort of other evidence at this point) like a parameter sniffing issue.Answered | 3 Replies | 1216 Views | Created by ESQL5 - Wednesday, March 19, 2014 7:03 PM | Last reply by Atif-ullah Sheikh - Wednesday, March 19, 2014 7:30 PM -
0 Votes
Issues with the Stored Procedure
For your First issue, you can use something like this: Insert Into WDFact Select ...Answered | 12 Replies | 2317 Views | Created by MkrTOM - Wednesday, July 27, 2011 4:24 PM | Last reply by MkrTOM - Wednesday, July 27, 2011 6:38 PM -
0 Votes
stored procedure
Stored procedure basics http://msdn.microsoft.com/en-us/library/ms191436(v=SQL.90).aspx Types of Stored ...Answered | 4 Replies | 4610 Views | Created by Classic Run - Friday, April 30, 2010 1:53 AM | Last reply by Ramesh Rathod - Friday, April 30, 2010 10:30 AM -
0 Votes
Stored Procedure Subquery Issue
Hi, In the below stored procedure, I often get this error message...Answered | 8 Replies | 7235 Views | Created by obrienkev - Friday, September 10, 2010 1:42 PM | Last reply by Jon Royales - Friday, September 10, 2010 4:02 PM -
1 Votes
Call a stored procedure from a stored procedure
Hi Dave, Is this still an issue ?Answered | 5 Replies | 1597 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Chongtham Rajen Singh - Sunday, October 13, 2013 1:46 AM -
1 Votes
store procedure read issue...
For example: Grant Execute on sp_helptext to [login] Now the user could use this command to see definition of the trigger or stored procedure.Answered | 3 Replies | 2110 Views | Created by MSDN_12345 - Wednesday, September 4, 2013 1:26 PM | Last reply by Candy_Zhou - Thursday, September 5, 2013 10:10 AM -
0 Votes
Stored Procedures
Compilation step is required only once when the stored procedure is created.Answered | 6 Replies | 2689 Views | Created by shivashankara - Wednesday, June 13, 2012 9:23 PM | Last reply by Erland Sommarskog - Wednesday, June 13, 2012 10:00 PM -
0 Votes
Convert Existing Stored Procedure To CLR Stored Procedure
Your stored procedure is almost completely SQL statements, so converting it to .NET would not only be slower, but possibly less secure (because users would need direct table access).Answered | 1 Replies | 7077 Views | Created by azinyama - Monday, November 5, 2012 8:55 AM | Last reply by Bob Beauchemin - Monday, November 5, 2012 5:59 PM -
0 Votes
Stored Procedure
If I understand this correctly, you first run a stored procedure that saves data into a table.Answered | 8 Replies | 3950 Views | Created by Binggoy - Monday, October 3, 2011 5:08 AM | Last reply by Steen Schlüter Persson - DK - Monday, October 3, 2011 8:39 AM - Items 1 to 20 of 1547283 Next ›
No announcements
