When altering the structure of tables it is good practice to run SP_RECOMPILE against the table to force triggers and stored procedures to recompile. However this does not incude Udf's which also rely on the table, and this means the Udf's may fail when they are called. Run this script and supply the table name […]
2002-09-05
353 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
By Steve Jones
If you have any doubt about being able to carry a load in one...
Hi everyone I have a SP that just failed. Format of SP is: Select...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Comments posted to this topic are about the item Creating a new API in...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers