Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
Writing Agent Job Step Output to a Log File on Disk
Preserve job step output in a server-side file, configure Agent tokens and append flags, and verify write permissions and retention.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.
Searching the Error Log by Date and Text With xp_readerrorlog
Search the SQL Server error log by date and text, select archives, capture matching rows, and cycle logs without losing context.
When Did SQL Server Last Restart? Four Ways to Check
Find SQL Server’s last restart using startup metadata, tempdb, logs, and sessions, then interpret reset counters correctly.
SQL SERVER – Who Dropped Table? Part 2
There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.