In newer versions of SQL Server, the TempDB configuration is dynamic based on the number of CPUs. If you are on an older version, you want to ensure that you have the same number of data files as ...

It has been enhanced with each later version of the SQL Server database engine since SQL Server 2008. Extended Events has had a slow uptake in usage as there was no user interface available until ...

For more information about strong password requirements, see “Database Engine Configuration – Account Provisioning” in Setup Help or in SQL Server 2019 Books Online.

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work. Any ...

SQL Server has an optimizer that usually does a great job of optimizing code for the most effective execution. A query execution plan is the breakdown of how the optimizer will run (or ran) a query.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup If you need to know where the actual SQL engine is located, look at the tag SQLPath , which is also in this same node.

Microsoft introduced a preview of the latest edition of its flagship RDBMS, SQL Server 2019, highlighting new Big Data capabilities. The company said v2019 creates a unified data platform by packaging ...