SQL 2016 – It Just Runs Faster: Automatic TEMPDB Configuration

Moved from: bobsql.com
 
Various KBs, whitepapers and blogs have outlined the need for the creation of multiple, TEMPDB files, same sized files, trace flags and the like.   All of these configuration options increase the scalability… Continue reading SQL 2016 – It Just Runs Faster: Automatic TEMPDB Configuration

SQL 2016 – It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases

Moved from: bobsql.com
 
Configuration of TEMPDB is often critical to scalability and throughput of SQL Server applications.  The following link (https://support.microsoft.com/en-us/kb/2964518) outlines how to configure SQL Server 2014 a… Continue reading SQL 2016 – It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases

SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)

Moved from: bobsql.com
 
Table Valued Parameters (TVPs) containing spatial columns can be used as input parameter(s) to stored procedures.  SQL Server 2016 improves the scalability, using native spatial validation(s), increasing performa… Continue reading SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)

SQL 2016 – It Just Runs Faster: DBCC Extended Checks

Moved from: bobsql.com
 
Last week’s post (SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better) talked about several improvements to DBCC CHECKDB to make it run faster. In today’s post, we will talk about additional improvements to extended logi… Continue reading SQL 2016 – It Just Runs Faster: DBCC Extended Checks