Database details for Daily checks
Get database status,file details,free space
in sql 2005 and 2008 sql versions
2013-01-16 (first published: 2012-12-07)
2,534 reads
Scripts
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,773 reads
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED
I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database
2013-01-08 (first published: 2008-10-23)
3,220 reads
The Ultimate Missing Index Finder
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
2013-01-07 (first published: 2008-08-01)
21,352 reads
Search All Stored Procedures in a Database
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,702 reads
2013-01-03 (first published: 2009-02-17)
8,237 reads
Find Largest size Tables in a Database
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,327 reads
Generate Drop / Create Script for views, stored Procedures
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,378 reads
The Ultimate Index Usage Reporter
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
2012-12-27 (first published: 2008-08-01)
8,011 reads
Show Table, Index and Image/Text size.
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,735 reads
Blogs
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...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Alamat BCA KCP Metro Tanah Abang Telp:0821°7555°651
Hub Cs 08217555651 Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H....
BCA KCU MENARA BCA Telp/Wa:08218200203
Hub Cs 08218200203 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat BCA KCP Raden Saleh Telp/Wa:08218200233
Hub Cs 08218200233 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec....