When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
3,842 reads
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
346 reads
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
21,111 reads
2016-10-07 (first published: 2016-09-20)
1,519 reads
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
783 reads
2016-10-04 (first published: 2016-09-19)
440 reads
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
567 reads
This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views
2016-09-26 (first published: 2016-08-25)
455 reads
2016-09-23 (first published: 2016-08-30)
558 reads
2016-09-20 (first published: 2016-08-17)
1,012 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers