I've noticed some confusion amongst VB6 programmers who've moved to .NET regarding garbage collection, so I'd like to explain the differences. VB6 is built on top of COM. In COM, each object has a hidden reference count inside it, a count of the number of in scope variables that point to the object. When you new an object the reference count is set to 1. If you then assign that variable to another, the reference count is incremented to 2. As those references go away, either by variables going out...

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/X9v

My project is on the move, literally. We're migrating from our old data center to a new one; everything is being brought up on new hardware. Since we're using full and incremental backups, an important sanity check is to make sure all the data has been restored, which is being done using the following query: select 'select ''' + TABLE_SCHEMA + ''' as TableSchema, ''' + TABLE_NAME + ''' as TableName, count(*) as [Rows] from ' + TABLE_SCHEMA + '.' + TABLE_NAME + ' union' as [SQL] from INFORMATION_SCHEMA.TABLES...

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/X9N