Triggers come in two kinds, Instead of and After. Here is how an Instead of Trigger can intercept an insert, update or delete on a table, with an example.
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
SQL Server has no TRIM function, and calling it gives error Msg 195. This SQL in Sixty Seconds video shows how to remove leading and trailing spaces without it.
SharePoint Conference Singapore 2013: A Great Experience
I had the great pleasure of presenting at SharePoint Conference Singapore 2013, my second visit to the event. I shared three database tips in a session inspired by SQL in Sixty Seconds, and the room overflowed. Here is my recap, with photographs.
Grandfather-Father-Son Retention: Choosing Which Backups to Keep
Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.
Designing a Date Dimension
A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.
Why Table Size Numbers Disagree: Reserved, Used and Unused Space
Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.
SQL SERVER – A List of Various SQL Server RTM and Service Pack Number
Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.