Clear Transaction Log in T-SQL This T-SQL script will clear out a SQL Server transaction log, which will shrink the size of your database. If your database gets a lot of activity, the transac... more
T-SQL
Code
Create Bill of Materials Table This T-SQL script creates a simple Bill of Materials (BOM) table and also creates an index on the ParentSKU field.The Bill of Materials ID field (BOMID) is alre... more
Lee's Code RSS Feed
