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 […]
Tag: T-SQL
Tips for using SQL Server 2012 Integration Services (Part 1)
Tips for using SQL Server 2012 Integration Services (Part 1) Integration Services (SSIS) were first introduced in SQL Server 2005 and replace the Data Transformation Services (DTS). By using the SSIS you can load data into or out from SQL Server relational databases or data warehousing. In this article, you can find some tips to boost the SQL Server 2012...
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
Register
Already a member? Log in here
SQL Server 2012 Transact-SQL Optimization Tips
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
Register
Already a member? Log in here