Stored Procedure to Pause Execution
Ever needed to pause in a SQL script? Or wanted to simulate a long running process for testing? This stored procedure accepts an integer and pauses for that many seconds.
2002-10-04
1,157 reads
Blogs
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray
In this series of blog posts, we’re diving into how to use the Pure...
Forums
temp table filtering with Joins question
Hello Gurus for one use case we converted the code to use temp tables...
checkdbcc date for all database
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
Azure Postgres reliability/management experiences
I am considering implementing an Azure Postgres DB for use in a part of...
Ask SSC