The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error …
Read More »Reorganizing Indexes Using SQL Server Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of reorganizing the indexes. I will …
Read More »Select Into Statement in SQL Server(TSQL)
We use the Select Into Statement to export the data in a table to another table. You can see a few examples below. First, …
Read More »Insert Into Statement in SQL Server(TSQL)
We use the Insert Into Statement to add data to a table. We can use the Insert Into Statement in a number of different ways. …
Read More »Select Statement in SQL Server(TSQL)
We use the Select statement to read data from the database. If we want to read the specific columns in the table, we need to …
Read More »Cannot enable compression for object
ERROR: Msg 2786, Level 16, State 1, Procedure sp_estimate_data_compression_savings, Line 20 The data type of substitution parameter 3 does not match the expected type …
Read More »How To Add Email Notification for Scheduled Job
It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following …
Read More »DBCC CHECKCONSTRAINTS Command On SQL Server
DBCC CHECKCONSTRAINTS checks the consistency of a specified constraint, or all constraints in a table. So what is Constraint? Constraints are the restrictions …
Read More »How To Move a Datafile in the File System to the ASM Disk Group
Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …
Read More »DBCC CHECKFILEGROUP Command On SQL Server
DBCC CHECKFILEGROUP checks the consistency of all tables and indexed views on the filegroup. To examine in more detail what Filegroup is, you can read …
Read More »