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 ...

SQL Server includes much more than the database engine. Tools like Reporting Services (SSRS) and Analysis Services (SSAS) have long been a core part of the value proposition of SQL Server.

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 ...

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.

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.

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 ...