Tag: SQL Server 2014

Pro Members SQL Server Standard Members

Some tips for using views in SQL Server 2014

by

Some tips for using views in SQL Server 2014 Consider using indexed views. Indexed views can significantly improve the performance of an application because the result set of the indexed view is stored and indexed in the database. You do not need to modify your existing applications to take advantage of the performance improvements with indexed views. The indexed view...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2014

by

Some tips for using ASP.NET with SQL Server 2014 If you use ADO to access SQL Server data in your ASP.NET, avoid creating transactions using ADO methods. Try to create transactions inside a stored procedure on the SQL Server. By doing so, you can reduce network traffic and boost overall ASP.NET performance. When building a web page based on SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using query hints in SQL Server 2014

by

Tips for using query hints in SQL Server 2014 If you want to set any hints for your query, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2014 query optimizer usually proposes the best execution plan, you should test the query with hint and use this hint only when...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using table hints in SQL Server 2014

by

Tips for using table hints in SQL Server 2014 One of the ways to increase the queries performance is using the SQL Server 2014 table hints. The table hints specify a locking method to be used by the query optimizer with this table, specify the locking granularity for a table, or one or more indexes to be used by the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips to work with SQL Server 2014 alerts

by

Some tips to work with SQL Server 2014 alerts SQL Server writes the events to the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. An alert is an automated response to events raised by SQL Server. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2014

by

Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 file and filegroups

by

Tips for using SQL Server 2014 file and filegroups Set the reasonable sizes for the database and transaction log. First of all, before database creation, you should estimate how large your database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Microsoft SQL Server security best practices checklist – Part -1

by

Microsoft SQL Server security best practices checklist – Part -1 Author: Basit A. Farooq Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data such as customer information and other confidential business data. Because of this, it is not wrong to say that databases such as SQL Server are the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Transactional Replication Optimization Tips

by

SQL Server 2014 Transactional Replication Optimization Tips Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the distributor on the same physical server when the publisher server can perform the distribution tasks without any performance problems. By the way, using a separate SQL Server for the Distributor requires separate SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Snapshot Replication Optimization Tips

by

SQL Server 2014 Snapshot Replication Optimization Tips Do not configure the Distribution Agent to run continuously. Try to schedule the Distribution Agent to run at regular intervals instead of running continuously. By using it, you can decrease the total SQL Server overhead. Consider placing snapshot folder on a disk that is not used to store database or log files. Placing...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 4 5 6 7 8