Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains...
Author: Alexander Chigrik
Tips for using SQL Server 2014 Database Console Commands
Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains […]
Tips for using indexes in SQL Server 2014 (Part 2)
Tips for using indexes in SQL Server 2014 (Part 2) Create a clustered index for each table. If you create a table without clustered index, the data rows will not be stored in any particular order. This structure is called a heap. Every time data is inserted into this table, the row will be added to the end of the...
Tips for using indexes in SQL Server 2014 (Part 2)
Tips for using indexes in SQL Server 2014 (Part 2) Create a clustered index for each table. If you create a table without clustered index, the data rows will not be stored in any particular order. This structure is called a heap. Every time data is inserted into this table, the row will be added to the end of the […]
Tips for using indexes in SQL Server 2014 (Part 1)
Tips for using indexes in SQL Server 2014 (Part 1) Keep your indexes as narrow as possible. Because each index takes disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Use the WAIT_AT_LOW_PRIORITY option with ALTER INDEX statement....
Some tips for designing SQL Server 2014 tables
Some tips for designing SQL Server 2014 tables Create the table’s columns as narrow as possible. This can reduce the table’s size and improve performance of your queries as well as some maintenance tasks (such as backup, restore and so on). Try to reduce the number of columns in a table. The fewer the number of columns in a table,...
Some tips for using Very Large Databases in SQL Server 2014
Some tips for using Very Large Databases in SQL Server 2014 Consider using table and index partitioning. In SQL Server 2014 tables and indexes can be divided into partitions based on value ranges. By using partitioning, you can transfer blocks of data within the database schema more efficiently because maintenance operations can be performed against single partitions instead of an...
Tips for using tempdb database in SQL Server 2014
Tips for using tempdb database in SQL Server 2014 Permit the tempdb database to automatically grow. Autogrow feature is set by default. Each time the SQL Server 2014 is started, tempdb database is recreated and reset to its default size. Automatically growing results in some performance degradation, therefore you should set a reasonable size for tempdb database and a reasonable...
Tips for using SQL Server 2014 Profiler
Tips for using SQL Server 2014 Profiler SQL Server 2014 Profiler is a graphical user interface to create and manage traces and analyze and replay trace results. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and...
Tips for using Integration Services in SQL Server 2014 (Part 2)
Tips for using Integration Services in SQL Server 2014 (Part 2) Use the bcp utility instead of Integration Services when you need to export data from the SQL Server table into a text file. The bcp utility is much faster than SSIS, so try to use it whenever possible. If you need to sort data or identify similar data rows,...