Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,580 reads
Scripts
2014-03-31 (first published: 2014-03-03)
1,247 reads
DBCC,Backup, Verify and create Agent Job to restore
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,079 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,363 reads
Script to Check the Database Backup duration
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,143 reads
Script to Get the Database Restore history
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,314 reads
Script to Get the Backup History
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,545 reads
2014-03-13 (first published: 2014-02-25)
1,114 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
2,196 reads
Find Size of files used in Database
This script will help in identifying file size of primary file, log file and all partition files. This include free space available and space used for each file in a database.
2014-03-03 (first published: 2014-02-20)
1,266 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCP Menara Imperium Telp:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. H. R. Rasuna Said No.Kav. 01, RW.6, Guntur, Kecamatan Setiabudi,...
Alamat BCA KCP Sejati Mulia Telp:0821-8200-203
Telp/Wa 62 821-8200-203 Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, RT.3/RW.3, Jati Padang,...
Alamat BCA KCP Graha Inti Fauzi Telp:0821-8200-174
Telp/Wa 62 821-8200-174 Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt. Dasar, RT.2/RW.7,...
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers