You have a DBCC CHECKDB script running, something like the following, and it may take several hours to run to confirm if there is any corruption in your SQL Server Database. Then someone asks you the age old question… When will it be done? You look at the window running the command and you can see how long it …
DBCC CheckDB or CheckTable – Find percent complete Read more »
The question of how to delete a trigger after a specific date came up. Here is what could be done. If you want to trigger to disappear after a specific date or time, you can just drop the trigger from inside the trigger itself. Something like this. If instead of dropping the trigger you just want to disable it, …
Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes with the video. See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 …