Tag: table

Pro Members SQL Server Standard Members

SQL Server 2014 Transact-SQL Optimization Tips (Part 2)

by

SQL Server 2014 Transact-SQL Optimization Tips (Part 2) Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Consider using the CONTAINS...

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 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access...

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 →
SQL Server

SQL Server 2014 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access […]

Continue Reading →
Pro Members SQL Server Standard Members

Some tips for designing SQL Server 2014 tables

by

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,...

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 2012 Transact-SQL Optimization Tips

by

SQL Server 2012 Transact-SQL Optimization Tips Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Avoid using optimizer hints in your...

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 2012 Table Hints

by

Tips for using SQL Server 2012 Table Hints One of the ways to increase the queries performance is using the SQL Server 2012 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 query...

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 2012 User-Defined Functions

by

Tips for using SQL Server 2012 User-Defined Functions If you want to invoke a stored procedure directly from a query and this stored procedure returns a scalar value, consider replacing a stored procedure with a scalar user-defined function. A stored procedure cannot be invoked from the SELECT statement, but if you need to invoke some code inside the query, try...

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 →