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)
928 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)
928 reads
This script will drop a mail for sql drives if space on drives is below set threshold value. Log drives with 15 and data files drives with value of 10% as threshold value of free space.
2015-11-19 (first published: 2015-10-27)
2,611 reads
2015-11-18 (first published: 2015-10-29)
934 reads
Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.
2015-11-17 (first published: 2015-10-18)
2,038 reads
This script is used to compress tables and indexes. It is designed for page compression on all. Just a little ditty to help with our EDW storage and processing.
2015-11-11 (first published: 2015-10-09)
1,310 reads
This scripts calculates the first day and the last day of a given week
2015-11-10 (first published: 2015-10-12)
1,148 reads
2015-11-10 (first published: 2007-04-05)
426 reads
2015-11-10 (first published: 2011-08-13)
1,957 reads
Get FirstDate and LastDate of Every month from two Dates.
Like IF we have @date1='05/02/2015' and @date2= '11/25/2015' then we will get list of first date and last date from month 5 to 11.
SELECT ID,FirstDate,LastDate,Month,Year FROM [GetFLDatelist](@date1,@date2)
2015-11-09 (first published: 2015-10-09)
1,252 reads
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,925 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Comments posted to this topic are about the item Computer Algebra
Comments posted to this topic are about the item Renaming a Database
Comments posted to this topic are about the item A First Look at SSMS...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers