Author: Alexander Chigrik

Pro Members SQL Server Standard Members

Tips for using bulk copy in SQL Server 2014

by

Tips for using bulk copy in SQL Server 2014 Use native mode bulk copy whenever possible. Because native mode bulk copies are generally faster than character mode, you should use native mode bulk copy whenever possible. Note. Now the bcp utility supports native data files compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2,...

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 backup and restore in SQL Server 2014

by

Tips for using backup and restore in SQL Server 2014 Consider using SQL Server backup (restore) to (from) URL. In SQL Server 2014 you can use SQL Server Management Studio to backup to or restore from Windows Azure Blob storage service. This new option is available both for the Backup task, and maintenance plans. Use SQL Server 2014 backup encryption....

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 constraints in SQL Server 2014

by

Tips for using constraints in SQL Server 2014 Use CHECK constraints instead of rules. Rules are provided for backward compatibility and have been replaced by CHECK constraints. Constraints are much more efficient than rules and can boost performance. Rules have some restrictions. For example, only one rule can be applied to a column, but multiple CHECK constraints can be applied....

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 temporary tables in SQL Server 2014

by

Tips for using temporary tables in SQL Server 2014 Consider using memory-optimized table variables instead of a traditional table variable to reduce tempdb use. SQL Server 2014 introduced In-Memory OLTP (In-Memory Optimization). In-Memory OLTP introduces the memory-optimized tables and the memory-optimized table type. A table variable created using a memory-optimized table type is a memory-optimized table variable. Memory-optimized table variables...

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 User-Defined Functions in SQL Server 2014

by

Tips for using User-Defined Functions in SQL Server 2014 Try to avoid using nested user-defined functions. Because using nested user-defined functions can result in some performance degradation, try to break down a nested function into simpler functions. Consider using CLR user-defined functions. The CLR user-defined functions were first introduced in SQL Server 2005. You can write the user-defined functions in...

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 XML in SQL Server 2014

by

Tips for using XML in SQL Server 2014 Use SQLXML instead of Native XML Web Services. Beginning in SQL Server 2014, the Native XML Web Services is removed. So, you can no longer use CREATE ENDPOINT or ALTER ENDPOINT to add or modify SOAP/HTTP endpoints. Consider using the RAW mode of FOR XML queries, instead of AUTO or EXPLICIT modes....

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 Distributed Queries

by

Tips for using SQL Server 2014 Distributed Queries One of the first steps to optimize distributed queries against a SQL Server 2014 linked server is rewriting queries so, that the most work will be performed on the remote server, not the local server. You can run the remote query from Management Studio and take a look at the query plan...

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 cursors

by

Tips for using SQL Server 2014 cursors Try to avoid using insensitive, static and keyset cursors, whenever possible. These types of cursor produce the largest amount of overhead on SQL Server 2014, because they cause a temporary table to be created in TEMPDB, which results in some performance degradation. Use FAST_FORWARD cursors, whenever possible. The FAST_FORWARD cursors produce the least...

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 triggers

by

Tips for using SQL Server 2014 triggers Try to minimize the DML trigger’s code size. Triggers fire during INSERT, UPDATE, or DELETE statements, so the more code that runs in the trigger, the slower each INSERT, UPDATE, and DELETE that fires it will be. Use cascading referential integrity constraints instead of triggers whenever possible. For example, if you need to...

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

Undocumented SQL Server 2012 Full-Text Search Stored Procedures

by

Undocumented SQL Server 2012 Full-Text Search Stored Procedures SQL Server 2012 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog name...

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 … 28 29 30 31 32 … 42