Using the technique I discussed in this post, the following SQL Server stored procedure can be used to display the space used for all tables in a specified database. Put the stored procedure into whatever database you use for your Utilities … [Continue reading]
Run a SQL Server Stored Procedure inside any Database using a Parameterized Database Name
Running a SQL Server Stored Procedure in the context of an arbitrary database that is specified at runtime is usually very difficult. By using dynamic SQL, however, you can pass a database name as a parameter to the stored procedure and run the SQL … [Continue reading]
The Start / About Me
How does one start blogging? They just start. After many times saying "I really need to start blogging", this is my start. About Me My name is Bill Bartlett. I've been deeply immersed in almost all aspects of software architecture, design, … [Continue reading]