For 100% polyester fabrics use 1.5 lb. of dye per 100 lbs. of fabric (1.5% OWG) to get medium shades. (With black, you are going to get more of a charcoal grey with this product.) That would be 6 - 4 oz packets, so 3 for 50 lbs. of fabric, etc.
XML data type was introduced in SQL Server 2005. This type allows you to store XML data up to 2 GB. Here is a small example of, pretty much self-explanatory.
You can use Sql Server Profiler for this purposes it provides a lot of useful info along the each executed query and Stored procedure as well. MSDN: SQL Profiler Data Columns. SQL Profiler displays the execution time for each event.An other straightforward way:1  DECLARE 2 datetime variables: start/end.2  SET start = GETDATE(). 3  EXEC SP_NAME.4  SET end = GETDATE().SDN: SQL Profiler Data Columns. SQL Profiler displays the execution time for each event. An other straightforward way: 1  DECLARE 2 datetime variables: start/end. 2  SET start = GETDATE(). 3  EXEC SP_NAME. 4  SET end = GETDATE().