Tag: performance

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 cursors

by

Tips for using SQL Server 2012 cursors Reduce the number of rows to process in the cursor. To reduce the cursor result set use the WHERE clause in the cursor’s select statement. Use FAST_FORWARD cursors, whenever possible. The FAST_FORWARD cursors produce the least amount of overhead on SQL Server 2012, because there are read-only cursors and can only be scrolled...

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 bulk copy

by

Tips for using SQL Server 2012 bulk copy Use the -K option of the bcp utility. This option was first introduced in SQL Server 2012. If you specify "ReadOnly" for the -K option the read-only access to a secondary replica in an AlwaysOn availability group will be used. Consider using minimally logged bulk copy whenever possible. The minimally logged bulk...

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 triggers

by

Tips for using SQL Server 2012 triggers Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these new features, but usually using them provides more easy and effective way to accomplish the same goal. In this article, you can find some tips to use triggers in SQL Server 2012. 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 →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2008 R2 database settings

by

Tips for using SQL Server 2008 R2 database settings To change the database settings, you can use the sp_dboption system stored procedure or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand...

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 … 6 7 8