Most of the organizations use an SQL server to manage their vast data. The SQL server offers both automatic shrinking and auto growing of SQL database files. It causes index fragmentation in the physical files, which leads to poor performance. To avoid this problem, you have to disable auto shrink feature in SQL Server databases. […]
Why to Repair Clustered Index in SQL Server? A large number users of the SQL Server have to deal with a variety of problems while working with the SQL Server database. A majority of these are related to corruption of database files. As data is the essence of all the operations and forms the foundation […]
When the database CHECKDB task gets completed .This does is a frequent question asked my Team Leads/Managers or else any one. Buy UN fortunately SQL Server Management Studio does not help us n o this. No Worries we from SQL Server 2005 and above we have DMV to help us out. use master go SELECT […]
Hi All Think you have to install sql server server pack to all the SQL Server in a Server. and Attended installation takes much time and human interferance, here is a simple idea solution for it .Install SQL Server Latest Service Packs from Command Prompt. its the easiest method to implement. Before proceding please take […]
SQL Server 2012 installation in Simple steps ,please check the Step by Step Process For Prereqiusite check thi url http://msdn.microsoft.com/en-us/library/ms143506.aspx Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Restart the Server and it is done