Author

Massively Parallel Processing (MPP)

MPP database is a type of database or data warehouse where the data and processing power are split up among several different nodes (servers), with one leader node and one or many compute nodes. MPP databases can scale horizontally by adding more compute resources (nodes), rather than having to worry about upgrading to more and more... » read more

Microsoft Distributed Transaction Coordinator (MSDTC)

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As the name says, MSDTC is a Windows service providing transaction infrastructure for distributed systems. In this case, a transaction means a general way of structuring the interactions between autonomous agents in a distributed system. The Microsoft Distributed Transaction Coordinator service is a component of modern versions of... » read more

Check for SQL Server Mail Profile

Check whether mail profile has been setup on the server. The following will return mail profile that has been setup. The query will return no records if mail profile has not been setup.

sp_updatestats

Runs UPDATE STATISTICS against all user-defined and internal tables in the current database. Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently... » read more

sp_delete_jobsteplog

Removes all SQL Server Agent job step logs that are specified with the arguments. Use this stored procedure to maintain the sysjobstepslogs table in the msdb database.

sp_delete_backuphistory

Reduces the size of the backup and restore history tables by deleting the entries for backup sets older than the specified date. Additional rows are added to the backup and restore history tables after each backup or restore operation is performed; therefore, we recommend that you periodically execute sp_delete_backuphistory. The backup and restore history tables... » read more

sp_purge_jobhistory

Removes the history records for a job. Example Purge job history records older than 30 days. Sources: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-purge-jobhistory-transact-sql?view=sql-server-2017

PowerShell

PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language. Can be run as Jobs in SQL Server. Example Remove all files greater than a certain date. PowerShell Commands Here are 25 basic PowerShell commands: Command name Alias Description Set-Location cd, chdir, sl Sets the... » read more