Opinions, tips, and news orbiting Microsoft
Moved from bobsql.com
Database Instant File Initialization was added several SQL Server releases ago. The instant file initialization feature scales the creation and expansion (growth) of database, DATA files. &n… Continue reading SQL 2016 – It Just Runs Faster: Instant File Initialization
Moved from: bobsql.com
When creating or growing the database log file (LDF) a byte pattern is stamped. The pattern establishes the proper log block layout with end of log marker(s.)
SQL Server 7.0 changed the LDF format from th… Continue reading SQL 2016 – It Just Runs Faster: LDF Stamped
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
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
Moved from: bobsql.com
Index creation and tessellation are often intensive, spatial activities. Along with the native and TVP, spatial enhancements additional work to optimize index creation and tessellation was completed…. Continue reading SQL 2016 – It Just Runs Faster: Spatial Index Builds Faster
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)
Moved from: bobsql.com
Spatial data is among, if not the fastest, growing storage types for the SQL Server database. It is common place for customers to have 3,000,000 or more rows in a database. Customers are t… Continue reading SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)
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