An index is a copy of information from a table that speeds up retrieval of rows from the table or view. Two main characteristics of an index are: Smaller than a table – this allows SQL Server to search the index more quickly, so when a query hits a particular column in our table and if... » read more
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of space. You got it, absolutely none! Now before you get too excited (and some of you did didn’t... » read more
Even if you’re not writing to different physical drives, you can get faster backups with Microsoft SQL Server when you back up to multiple files. Your exact numbers are going to vary based on your server. Test round 1:Backing up to multiple files on one volume In this test, the backup files were on one... » read more
Problem: User create SQL Account on local database. Unable to connect using SQL Account. Fix: Make sure “SQL Server and Windows Authentication mode” is selected in Server Properties of SQL Server. Restart database server.
Extract ISPAC file SSMS -> Integration Services Catalogs -> SSISDB -> MyProject01 -> right click and click on “Export” XXXX.ispac file will be generated. Rename the .ISPAC file to .ZIP, after that you can to extract all files from that zipfile. Sources: http://microsoft-ssis.blogspot.com/2016/04/get-packages-from-ssis-catalog.html
When a job fails, you have set to have it alert an operator. For the operator setting, you can add multiple email address to the “E-mail name” field separated by semicolon. E-mail name: Edit via script… Note: There is a 100 character limit. It is set in the sysoperators table. DO NOT try to ALTER... » read more
Error: Getting the following error when running a stored procedure… SELECT INTO failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML Fix: Sources: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/95752aba-2c39-4aca-be2b-a2ee9e3d70da/select-into-failed-because-the-following-set-options-have-incorrect-settings-ansiwarnings?forum=sqldataaccess https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver15
Getting foreign key constraint error when trying to repopulate a table…
Error: Column ‘xxxxx’ is partitioning column of the index ‘PK_xxxxxxxx’. Partition columns for a unique index must be a subset of the index key. Could not create constraint or index. Solution: Since both biTable01Id, dtStartDateTime columns are in the partition column, both must be in the Primary Key column as well.