Tag: SQL Server 2016

SQL Server

Tips for using SQL Server 2016 cursors

by

Tips for using SQL Server 2016 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. Do not forget to close SQL Server 2016 cursor when its result set is not needed. To close SQL Server cursor, you can use CLOSE {cursor_name} command. This […]

Continue Reading →
SQL Server

SQL Server 2016 Reporting Services Optimization Tips

by

SQL Server 2016 Reporting Services Optimization Tips Use Reporting Services web portal. The Reporting Services web portal introduces in SQL Server 2016 and replaces Report Manager from previous releases. This is a modern portal which incorporates KPIs (Key performance indicators), Mobile Reports, Paginated Reports, Excel and Power BI Desktop files. Consider using the Chart data region. SQL Server 2016 supports […]

Continue Reading →
SQL Server

Tips for using constraints in SQL Server 2016

by

Tips for using constraints in SQL Server 2016 Try to create a single column constraint. The more columns the constraint will have, the slowly it will work and the more stored space it will require. Use default constraints instead of DEFAULT objects. DEFAULT object are provided for backward compatibility and has been replaced by default definitions (default constraints) created using […]

Continue Reading →
SQL Server

Tips for using tempdb database in SQL Server 2016

by

Tips for using tempdb database in SQL Server 2016 Use TempDB section of SQL Server Installation Wizard. SQL Server 2016 introduces the new UI input control on the Database Engine Configuration – TempDB section of SQL Server Installation Wizard. Now during setup, you can configure the number of tempdb database files, initial size, autogrowth and directory placement. You can specify […]

Continue Reading →
SQL Server

Tips for using SQL Server 2016 triggers

by

Tips for using SQL Server 2016 triggers Try to minimize the number of rows affected in a trigger. The more number of rows affected in a trigger, the more time a trigger takes to run. So, try to reduce the number of rows affected in a trigger. Consider using triggers on memory-optimized tables. SQL Server 2016 introduces supporting triggers on […]

Continue Reading →
SQL Server

Three Undocumented SQL Server 2014 Full-Text Search Stored Procedures

by

Three Undocumented SQL Server 2014 Full-Text Search Stored Procedures SQL Server 2014 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 […]

Continue Reading →
SQL Server

SQL Server security – (Part 1)

by

SQL Server security – (Part 1) SQL Server security is based around principals and securables. A principal is a SQL Server object that can be used to grant permissions to securables. A securable is any object that supports permissions. In the first part of the SQL Server security article series, you’ll learn about the two types of authentication SQL Server […]

Continue Reading →
Pro Members SQL Server Standard Members

New Features in SQL Server 2016

by

New Features in SQL Server 2016 Author: Basit A. Farooq During his keynote speech at Microsoft Ignite conference in Chicago, Microsoft Corporate CEO Satya Nadella announced that the first public preview of SQL Server 2016 will be available this summer. Finally, the wait is over and on the May 27, 2015, the first public preview of SQL Server 2016 was...

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