List of objects from particular schemas
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,182 reads
Scripts
2012-08-10 (first published: 2012-07-31)
1,805 reads
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,675 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)
979 reads
2012-08-03 (first published: 2008-01-09)
2,337 reads
2012-08-01 (first published: 2008-02-15)
3,248 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,398 reads
2012-07-25 (first published: 2012-07-12)
2,546 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,456 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)
764 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Alamat BCA KCP Menara Thamrin Telp:0821°7555°651
Telp/Wa 628217555651 Menara Thamrin, Jl. M.H. Thamrin No.Kav. 3 Lantai 1 Ruang 106, RT.10/RW.10,...
Alamat BCA KCP Duta Merlin Telp:08218200233
Telp/Wa 628218200233 Komp. Duta Merlin Blok A No. 24-25, Jl. Gajah Mada No.3-5, RT.2/RW.8,...
Alamat BCA KCP Tanah Abang Zona 3 Telp:08218200203
Telp/Wa 628218200233 Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp....
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers