Find Unindexed Foreign Keys (2005)
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,763 reads
Scripts
Monitor Any Linked Server From SQL 2005
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
2011-12-19 (first published: 2008-06-03)
3,314 reads
2011-12-16 (first published: 2007-12-27)
4,092 reads
Check Instance Info
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,598 reads
2011-12-14
361 reads
Select from stored procedure
This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.
2011-12-14 (first published: 2008-03-04)
4,159 reads
SQL 2005 Restore Script Generator
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,906 reads
Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,969 reads
Clear database - delete all records from a database (updated)
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,196 reads
2011-12-08 (first published: 2011-11-23)
1,145 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Alamat kantor BCA KCP Kutabumi Telp:082144477715
Wa:0821-4447-7715 Jl. Raya Kutabumi No.16-17 Blok B-18, Kutabumi, Kec. Ps. Kemis, Kabupaten Tangerang, Banten...
Alamat kantor BCA KCU GADING SERPONG Telp:082144477715
Wa:0821-4447-7715 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers