Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
500 reads
Scripts
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,272 reads
2009-12-18 (first published: 2009-11-26)
615 reads
2009-12-17 (first published: 2008-07-13)
1,859 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,206 reads
2009-12-14 (first published: 2007-10-19)
1,361 reads
Synchronize a stored procedure between two servers
Use this stored procedure to synchronize source code of a stored procedure between two servers.
2009-12-11 (first published: 2009-11-26)
2,017 reads
2009-12-09 (first published: 2009-11-18)
2,091 reads
2009-12-07 (first published: 2009-11-12)
3,094 reads
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
2,070 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers