Index rename to standards
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,086 reads
Scripts
Stored Procedures Performance
This script summarizes the execution statistics of the stored procedures which was run on the current database in the last 7 days.
2014-10-01 (first published: 2012-04-18)
7,374 reads
SQL Server Documenter
This script was designed to provide you with all the information needed to rebuild your server in case of a disaster. Current version work with 2005, 2008, 2008R2 and 2012.
2014-09-30 (first published: 2012-09-21)
8,276 reads
2014-09-29 (first published: 2010-02-04)
9,476 reads
Calculate Distance in Miles from Latitude and Longitude
A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.
2014-09-26 (first published: 2009-01-31)
9,214 reads
2014-09-25 (first published: 2010-12-23)
26,050 reads
2014-09-23 (first published: 2010-02-17)
11,483 reads
List all permissions in all databases
This script will allow you get all the users and roles with permission on objects on all databases.
2014-09-18 (first published: 2009-03-05)
35,711 reads
Calendar Table by Month
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
2,088 reads
Calendar Table by Day
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,998 reads
Blogs
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Forums
ALAMAT KONTAK BCA KCP Citraland Telp:08218154393
WA:08218154393 Citraland, Gateway Junction, Jl. Ruko No.1&2 Blok TL06, Lidah Kulon, Kec. Lakarsantri, Surabaya,...
ALAMAT KONTAK BCA KCP Prapen Telp:08218154393
WA:08218154393 Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
Developer edition cannot be connected from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers