Skip to main content

Posts

Showing posts with the label DBCC Commands

DBCC Commands

The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. DBCC commands take input parameters and return values. Database Console Command statements are grouped into the following categories. Category Maintenance -  Maintenance tasks on a database, index, or filegroup. Miscellaneous -  Miscellaneous tasks such as enabling trace flags or removing a DLL from memory. Informational -  Tasks that gather and display various types of information. Validation  - Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages. Maintenance Statements DBCC CLEANTABLE Reclaims space from dropped variable-length columns in tables or indexed views. Syntax: DBCC CLEANTABLE   (       { database_name | database_id | 0 }       , { table_name | table_id | view_name | view_id }       [ , batch_size ]   )...
Read more

Popular posts from this blog

SQL Server Services

Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. This topic describes the default configuration of services in this release of SQL Server, and configuration options for SQL Server services that you can set during and after SQL Server installation.  Most services and their properties can be configured by using SQL Server Configuration Manager. SQL Server Version and its last versions when Windows is installed on the C drive. Version Path SQL Server 2019 C:\Windows\SysWOW64\SQLServerManager15.msc SQL Server 2017 C:\Windows\SysWOW64\SQLServerManager14.msc SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc SQL Server 2014 (12.x) C:\Windows\SysWOW64\SQLServerManager12.msc SQL Server 2012 (11.x) C:\Windows\SysWOW64\SQLServerManager11.msc SQL Server 200...
Read more

Download SQL Server Management Studio (SSMS)

Summary:  In this post, you will learn &  able to download  SSMS. About  SQL Server Management Studio ( SSMS ):  SSMS is Free!! SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.   SSMS -  Prerequisites for Installation: SSMS supports the following 64-bit platforms when used with the latest available service pack: Supported Operating Systems: Windows 10 (64-bit) version 1607 (10.0.14393) or later Windows 8.1 (64-bit) Windows Server 2019 (64-bit) Windows Server 2016 (64-bit) Windows Server 2012 R2 (64-bit) Window...
Read more

SQL Server Tools - Microsoft Recommended Tools

Graphic User Interface (GUI-based Tools) SQL Server Management Studio (SSMS) SSMS SSMS is Free!!  SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud. SSMS -  Prerequisites for Installation: SSMS supports the following 64-bit platforms when used with the latest available service pack: Supported Operating Systems: Windows 10 (64-bit) version 1607 (10.0.14393) or later Windows 8.1 (64-bit) Windows Server 2019 (64-bit) Windows Server 2016 (64-bit) Windows Server 2012 R2 (64-bit) Windows Server 2012 (64-bit) Windows Server 2008 R2 (64-bit) Suppor...
Read more