Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,375 reads
Scripts
2012-03-30 (first published: 2008-04-21)
3,233 reads
Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,417 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,388 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,129 reads
2012-03-26 (first published: 2008-01-23)
3,272 reads
Different Date Formats
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,702 reads
Split Function to break the Job History Message into a Table
Split Function for T-SQL Server to break the Job History Message into Table.
2012-03-22 (first published: 2012-03-05)
1,107 reads
Session complete status and estimated completion time
A small retake on the popular percent complete script which tell how much more time an executing command will take.
2012-03-21 (first published: 2012-03-07)
1,644 reads
Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
929 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Alamat BCA KCP Semanggi Telp/Wa:08218200203
Hub Cs 08218200203 Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Alamat BCA KCP Kwitang Telp/Wa:08218200233
Hub Cs 08218200233 Jl. Kramat Kwitang No.29, RT.1/RW.4, Kwitang, Kec. Senen, Kota Jakarta Pusat,...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers