June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Computer Network, DBA, SQL Index, SQL Scripts
This issues was brought to me by our Sr. Network Engineer. While running operating system level de-fragmentation using either windows de-fragmentation or third party tool it always skip all the MDF file and never de-fragment them. He was wondering why this happens all the time. The reason MDF file are…
Read More

SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached

Pinal Dave
SQL
Computer Network, SQL Error Messages, SQL Server, SQL Server Security, SQL Utility

Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Read More