Symptoms When you use SSMS to run an SQL query that returns a large amount of data, you receive an error message that resembles the following: An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown Cause This issue occurs because SSMS has insufficient memory to allocate for large results.... » read more
Reason for converting a foreign key to a check constraint After partitional a table where the primary key was modified. If an additional column was added to the primary key, all the foreign key reference will now error out. You can either drop the foreign key or create a CHECK constraint insteac. If the table... » read more
Insert the content of files into a database table.
Note: Run the following on the source server and run the output on the destination server. Run after database has been restored. Apply to restored databases from PROD backup. Apply to AlwaysOn databases.
Moving data from Transaction database to Archive/Reporting database. After the records has been moved, delete the records to avoid duplicates. Note: If your database is involved in AlwaysOn or in Full Recovery mode, make sure you backup the database and log file to clear out the log files on the database before preceding. After you... » read more