2012-08-10 (first published: 2012-07-31)
1,796 reads
Scripts
2008 Index Rebuild using DMV
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
2012-08-09 (first published: 2012-07-26)
1,671 reads
Calculate alphabetic sequence
This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ
2012-08-08 (first published: 2012-07-25)
978 reads
2012-08-03 (first published: 2008-01-09)
2,336 reads
2012-08-01 (first published: 2008-02-15)
3,240 reads
2005 Online Index Rebuild using DMV
Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.
2012-07-31 (first published: 2007-10-09)
4,394 reads
2012-07-25 (first published: 2012-07-12)
2,531 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,450 reads
BusinessDaysToCalendarDays (For Unusual Business Weeks)
Tells how many calendar days are needed to complete a number of bussines days starting in a defined day of the week.
2012-07-23 (first published: 2012-07-04)
760 reads
BussinesDaysToCalendarDays
Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.
2012-07-20 (first published: 2012-07-04)
855 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....
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