Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,327 reads
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,327 reads
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
924 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers