Home of DJ and technophile Jonathan Puddle (aka J Puddy)
Archive for July, 2008
Visit to Toronto, in September and October
Jul 4th
I just booked flights for Maija and I to visit Toronto later this year. We’ll be there from September 26th till October 28th! It’ll be oh so lovely. We’ll be staying in the Etobicoke area, to allow me convenient access to work.
Exciting :)
Query a MSSQL database for table sizes
Jul 3rd
We use Microsoft SQL 2005 for our mission critical and web databases. In one instance, we’re able to use SQL Express just fine, but lately I had been keeping an eye on a DB that was approaching the 4GB limit imposed on SQL Express. I had a Google for queries to list the table sizes (it’s simple enough to find out the size of a single table in Management Studio, but querying is clearly simpler/faster). I found exactly what I was looking for, thanks to Scott Moss. Paste this below, replacing OnePoint with your DB name. Everything else is fine More >