SQLServerLog.com - Database Tips, Techniques and Tutorials
552viewsIn previous article we have seen how to backup system databases by creating maintenance plan. Here we will use T-SQL to backup all user and system databases with compression. You can also create SQL...
438viewsSQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize indexes, update statistics, backup databases and performs maintenance cleanup tasks etc. These...
ORDER BY clause is used to sort the data in ascending or descending order, in SQL Server by default data will not be inserted in any order even if you have an index. Syntax:...
1.7kviewsThe role of Database Administrator is very critical and important and DBA has to perform lots of activities and monitoring is one of the important task. A good DBA always tries to minimize his...
468viewsThis is very common issue and faced by many database users while connecting to database. When you try to connect to SQL Server, you may get error as: “A network-related or instance-specific error occurred...
If you want to find out which port is used by SQL Server then you can do the same by T-SQL or from SQL Server Configuration Manager (SSCM). Default port for SQL Server is...