Thursday, September 06, 2007

Max row size in SQL 2000 8060 bytes.
Max row size in SQL 2005 more then 8060 bytes if the table contains Var* or XML columns.  This is due to SQL 2005 Row-Overflow, this will affect performance of the database. ( the Varchar... will be moved to a separate page and a 24-byte pointer will be inserted into the original page.)

SQL database page size is 8KB or 8,000 bytes.
SQL data types    2000, 2005, 2008

char (N) = 1 * N bytes
varchar (N) = 1 * N + 2 bytes
nvarchar (N) = 2 * N + 2 bytes
DateTime = 8 bytes
Float = 8 bytes
ntext/text is being replaced with nvarchar(MAX)/varchar(MAX).  MAX = 2^31 - 1 bytes.
ntext/text is stored in separate page

 

Microsoft SQL Server 7.0 Storage Engine

Inside Microsoft® SQL Server™ 2005: The Storage Engine

Maximum Capacity Specifications for SQL Server 2005

SQL 2005 Fragmentation Information

posted by Aaron Fischer on Thursday, September 06, 2007 10:26:24 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

Doug Stewart has posted an extensive list of CRL 2.0 bug (hot)fixes.  Its worth a look if your Dot Net 2.0 app is having issues.  Thanks for putting together such a comprehensive list Doug. 

I have seen this issue on a QA server The managed heap becomes corrupted when you run a program that is built by using the Microsoft .NET Framework 2.0 good to see its not my code and that there is a fix for it.

Some of the Hot fix support articles do leave a little something to be desired though I would like to see Microsoft spend the time to detail the cause for each issue so I can better evaluate my need for a given fix.

posted by Aaron Fischer on Thursday, September 06, 2007 6:27:40 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Tuesday, August 28, 2007

The BBC announced The Apollo Image Archive today but did not provide a link so here is the Arizona State University and  NASA's Johnson Space Center's scanning of Apollo mission photos that have never been released to the public before. 

Here are a few other nice Galleries I have found over time.

Apollo Image Gallery

NASA Gallery

Astronomy Picture of the Day Archive

posted by Aaron Fischer on Tuesday, August 28, 2007 6:16:19 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Tuesday, August 21, 2007

Well I am officially on DasBlog 2.0 I didn't make the transition the way I wanted but, such is life.  I find it very nice that Scott Hanselman programmed the new compression the same way I did for my 2.0 release.  Thankfully this means I can continue to read all my log files from before my upgrade!  Now that I am upgraded I'll have to look into getting a new theme.

posted by Aaron Fischer on Tuesday, August 21, 2007 5:47:36 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

I leave work and Godaddy fubars my websites.  What a fun week.  I would appear updating to the new dasBlog corrected some issues and reuploading the entire websites corrected the other issue.  I Basically started over with Godaddy today.  I tried CrystalTech but can't host the subdomains and other sites how I would like, I will miss them.  I am not sure why I couldn't explain that if my blog engine worked fine Saturday and Sunday then it should still work fine on Monday!  And if it does not work I should see asp.net errors not server was reset...  I don't think a basic page like microfisch.com should take 30 seconds to load.  This makes nonsense to me.  I don't like the level of support I received from Godaddy so I will be looking for a new host.  If you have suggestions please let me know.

posted by Aaron Fischer on Tuesday, August 21, 2007 5:43:08 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

Did you miss me?? 

posted by Aaron Fischer on Tuesday, August 21, 2007 5:34:31 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Thursday, August 09, 2007

I have found and like DAEMON Tools 4.09 http://www.daemon-tools.cc
be careful it tries to install some "spy ware" software for their forums.

also we found Magic ISO to have a 64 bit version for vista. http://www.magiciso.com/tutorials/miso-magicdisc-overview.htm

posted by Aaron Fischer on Thursday, August 09, 2007 12:26:23 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]

I am now running windows vista 64.  Which has been surprisingly simple how ever I have run into a few issues.  Windows Explorer went insane and ignored the open in same window setting (note open in new process option was set to false.) resulting in a new window pre directory.  I find life impossible in that situation.  After numerous attempts to correct this via registry edits, I failed.  Having given up I installed xpore2 as a replacement. ( great program I always wanted to filter my directory to only one file type) I now find after a reboot Windows Explorer works correctly and recycles the the window when displaying a new directory.

I have also found that you cannot just install sql management studio 64bit.  you need to run(as admin) dvd drive:\Tools\Setup\SqlRun_Tools.msi otherwise you go through all the motions but nothing gets installed.

posted by Aaron Fischer on Thursday, August 09, 2007 12:19:59 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Thursday, August 02, 2007

Is it a Memory leak or a Resource leak.

It would seem that if you take a c++ managed extensions gc class containing a native pointer to dot net 2.0.  The classes finalization does not happen correctly.  Ie the destructor is no longer invoked.

further more if you migrate said c++ code to c++/cli then your destructor will not get called when the managed object is disposed of via garbage collection.  You will need to either explicitly call the destructor or add a finalize to your reference class.

 

Not the most obvious memory leak in the world to say the least.

posted by Aaron Fischer on Thursday, August 02, 2007 9:39:54 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]
 Saturday, July 28, 2007

Microsoft support has a Hotfix request Submission form now which promises;

To obtain this Hotfix, please submit your request via this form to Microsoft Online Customer Service and Support – you should expect to receive a download link via email from Microsoft within 8 business hours.

HotFix Request From

posted by Aaron Fischer on Saturday, July 28, 2007 8:33:04 AM (Pacific Standard Time, UTC-08:00)   #    Comments [0]