MSSQL

  We use the Select Into Statement to export the data in a table to another table. You can see a few examples below. First, …

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

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 …

  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 …

  DBCC CHECKCONSTRAINTS checks the consistency of a specified constraint, or all constraints in a table.   So what is Constraint? Constraints are the restrictions …

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 …

  In some projects or scenarios, we need to move some databases between different SQL Server editions. For example, in some organizations, SQL Server Evaluation …

  With a single command: [crayon-6745cbf1e455e160170233/] If you run this way, you will be opening this Trace Flag to Global, and even if your SQL …

  ERROR: Message Executed as user: DOMAIN\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002)  BACKUP DATABASE is …

  I was doing some security work to make a SQL Server production environment safer and ready for inspections. I had more than 900 SQL …