Max degree of parallelism (MAXDOP) is the SQL Server instance level setting that describes the number of processors or cores to be used for a particular query that is selected by the database engine to have a parallel execution plan.… Read More »What is max degree of parallelism in SQL Server
Error Message [SQLSTATE 42000] (Error 50000): Executed as user: DOMAIN\Account. SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator… Read More »SQL Error – SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’
Database upgrades to the higher version or most recent version are common nowadays to get the most from the new features available in the higher/latest version. In this article, we will share the steps to upgrade SQL Server 2012 to… Read More »How to Upgrade SQL Server 2012 to 2019
Sometimes developers need to insert the result of a stored procedure into a temporary table rather than just display the results. The stored procedure may contain select statements, the result of which might be require to store in temporary tables… Read More »How to insert the result of a stored procedure into a temporary table