Explorations in Code

Do you need to know the sizes for all the user tables in your database? I found this script by Mitchel Sellers, an SQL Server MVP ,  to be very handy. I've modified it slightly, but you can get the original on his blog . Thank you Mitchel for allowing me to post this here. Please excuse the poor formatting, I am working on finding and implementing a decent code formatted for both SQL and C#. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:            Mitchel Sellers - mitchel.sellers@gmail.com -- Create date: 2007/06/27 -- Description: Obtains spaced used data for --                            ALL user tables in the database. --            ...

Here's a stored procedure to generate a string of random characters. This is useful when, for example, one needs to generate a random password. Please excuse the poor formatting, I am working on finding and implementing a decent code formatted for both SQL and C#. Thanks to  Raymond Lewallen  over at CodeBetter.com SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:            Raymond Lewallen --                    http://codebetter.com/blogs/raymond.lewallen/archive/2005/05/17/63281.aspx -- Create date: 2005/05/16 -- Description: Generate a random string of --                            given length. --...