Tag Info

New answers tagged


Create a trigger on update (another on delete is probably a good idea). CREATE TRIGGER [Table].[uPreventUpdateOops] ON [Table] FOR UPDATE AS BEGIN DECLARE @Count int SET @Count = @@ROWCOUNT; IF @Count >= (SELECT SUM(row_count) FROM sys.dm_db_partition_stats WHERE OBJECT_ID = OBJECT_ID('Table') AND index_id = ...


For a database in SQL Server, there's a setting called Auto-Close, which is meant to minimize the amount of resources used while SQL Server is running, but no users are actively doing things. This setting is enabled by default in Express Edition instances, as those are usually running on developer workstations where performance isn't critical, and resources ...


It's not free but SqlSmash is also an addin for SSMS 2012, 2014. Disclaimer: I am the developer for the product

Top 50 recent answers are included