(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2008-05-21 (first published: 2007-10-11)
1,015 reads
2008-05-19 (first published: 2008-03-20)
940 reads
Script will list all identity columns with valus of 'Not for Replication'
2008-05-13 (first published: 2008-03-20)
748 reads
2008-05-09 (first published: 2006-07-03)
381 reads
i took the core from a script found in the site for generating permissions and update it.
2008-05-06 (first published: 2008-03-06)
3,575 reads
When run it will check the space left on the disk. If it was under 4GB it will raiserror.
2008-05-05 (first published: 2008-03-04)
1,446 reads
2008-05-01 (first published: 2008-03-06)
2,237 reads
A stored procedure which takes a year and language as parameters and creates a calendar display for these parameters.
2008-04-25 (first published: 2008-03-04)
1,028 reads
2008-04-24 (first published: 2008-02-28)
1,862 reads
2008-04-22 (first published: 2008-02-28)
1,684 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0818-751-777 Jl. Jend Sudirman No.46, Curah, Slawi Wetan, Kec. Slawi, Kabupaten Tegal, Jawa Tengah...
WhatsApp:0818-751-777 Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812...
WhatsApp:0818-751-777 Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa...
When running bcp on Linux, what is the field terminator?
See possible answers