Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,076 reads
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,076 reads
2012-12-14 (first published: 2012-11-27)
1,903 reads
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,576 reads
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
768 reads
2012-12-07 (first published: 2012-11-19)
1,373 reads
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
2012-12-06 (first published: 2012-11-16)
903 reads
2012-12-03 (first published: 2012-11-07)
1,983 reads
2012-11-30 (first published: 2012-11-03)
1,084 reads
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2012-11-29 (first published: 2012-10-31)
1,691 reads
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.
2012-11-27 (first published: 2012-10-18)
1,992 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers