Database Size
Fix: Shrink database file to recover unused space. Add more disk space. Purge data from database. Move data to another database or data warehouse. Sources:
.NETAgileAngularArchitectureASP.NETAzureBIBig DataBusinessC#Cloud ServiceDebuggingEncryptionFYIGoogleHardwareInternetInterviewsjQueryLeadershipManagementMicrosoftMobileMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Configure Database Always On
Configuring SQL Server Database Always On Availability Group Listeners are setup and all processes point to the listeners. Failover jobs have been setup. All jobs in the Always On category. XXXXX_AvailabilityGroup category. Failover Mode set to “Automatic”.
Drop Index
Drop Index Re-create Index Dropping index is fast. Recreating index will take a longer time.
Sparse Column
Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values. Consider using sparse columns when the space saved is at least 20 percent to 40 percent. Sources: https://docs.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?view=sql-server-ver15
Batch Update for Database
First always create backup of table to be updated. Batch update records in a database table.
Compress Database Backup Files with 7-Zip
7-Zip is a free and open-source file archiver, a utility used to place groups of files within compressed containers known as “archives”. It is developed by Igor Pavlov and was first released in 1999. 7-Zip uses its own 7z archive format, but can read and write several other archive formats. ZipFiles.cmd
Database Backup Log
Sources: https://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/
Database Table Definition List with Extended Property
Get a list of all tables in the database with their extended property value. Adding extended property to table. Update existing extended property to table. Sources: https://www.mssqltips.com/sqlservertip/5384/working-with-sql-server-extended-properties/
sp_help
Info about a table.
SQL Server Network Packet Size
The network packet size option sets the packet size (in bytes) that is used across the whole network. Packets are the fixed-size chunks of data that transfer requests and results between clients and servers. The default packet size is 4,096 bytes. Note: Do not change the packet size unless you are certain that it will improve... » read more