SQL Server 2016: configure TempDB during installation

Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended strategy is to create multiple data files, one per CPU core (logical processor), but not more than 8.  Those files should be equal in size and with the same autogrowth settings. In past, this had toContinue reading “SQL Server 2016: configure TempDB during installation”

Chris Webb's BI Blog

Microsoft Fabric, Power BI, Analysis Services, DAX, M, MDX, Power Query, Power Pivot and Excel

SQL Wes

SQL Blog Of Wes Springob

Data and Analytics with Dustin Ryan

Dustin Ryan is a Data Specialist interested in Azure, SQL Server, and Power BI.

SQL Server

for Application Developers

Gorandalf

Sharing knowledge on Azure Data Platform

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009