Tag: olline. OLTP

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 →