Temporary exclusive database access
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)
894 reads
Single User
Setting Single User Mode - SQL School Video
This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.
2009-07-16
4,187 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,685 reads
RE: Review: Log PI
Paul,My review took 16 hours to complete and was extremely thorough (it's over 20 pages). Believe me, the product was "actually" used. However, I did not test multiple transaction backups. Thank you for pointing out this bug. I am sorry to hear you were disappointed in the product. I thought it was outstanding.Please note: The assumption is that […]
2004-08-23
1 reads
RE: Error 3624
It may be a clustered index corruption. Have a look at MS Knowledge Base Article - 317852
2003-06-19
RE: Server Room Schedule
Haven't seen one. Used Excel myself. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-09
2 reads
RE: Error Traps In Triggers
By any chance is there a "working" SQL statement before the @@ERROR is checked - @@ERROR resets with every SQL statement... so if there was an error in an SQL statement and @@ERROR was not checked immediately after this statement did not execute but rather was checked after another "correct" SQL execution then the value […]
2003-06-04
1 reads
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers