StappsPlace.com

I have a few other planes that I have been working on as well and thought I would share some pics of those.

Piper Cherokee
Evo .46

Super Stick
OS .46

I have finally finished the Ultimate Biplane, it’s ready to fly. FYI, it’s extremely important to take tons of pictures when you have reached this point in an rc airplane project, right before the 1st flight!!!

I have been trying to perfect the art of reorganizing/rebuilding indexes in sql server here lately. I know that this is no where near perfection but is a step beyond the capabilities of SQL Server Management Studio simply because SSMS does not have the ability to take into account the percent of fragmentation. SSMS reorganizes and/or rebuilds every single index regardless of the fragmentation level, which can be a hard hit resource wise. This can also cause a maintenance plan to take several times longer than if the plan had the ability to respond dynamically. So, this is where it begins…..how to dynamically defrag indexes based on the percent of fragmentation. Transact SQL is the only way.

– 1. Reorganizes All Indexes Initially
– 2. Rebuilds Indexes IF Frag Is Not Cleared By Initial Reorganize
– Ignores Indexes <= 5% Fragmented
– Ignores Indexes With Page Count < 100
– Compatible With SQL Server 2005 And Later

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ‘IndexesToDefrag’) DROP TABLE IndexesToDefrag;

– Round 1 – Reorganize All Indexes With Frag > 5%

SELECT
si.name as IndexName,
OBJECT_NAME(si.object_id) as TableName,
avg_fragmentation_in_percent as Frag
INTO IndexesToDefrag
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, NULL) ips
Join sys.indexes si on ips.object_id = si.object_id
AND ips.index_id = si.index_id
WHERE avg_fragmentation_in_percent > 5
AND index_type_desc <> ‘HEAP’
AND page_count > 100;

DECLARE @Command VARCHAR(100)
DECLARE @Counter INT
DECLARE @IndexName VARCHAR(100)
DECLARE @NumberOfIndexes INT
DECLARE @TableName VARCHAR(100)
DECLARE @Frag INT

SET @NumberOfIndexes = (SELECT COUNT(*) FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, NULL) ips
Join sys.indexes si on ips.object_id = si.object_id
AND ips.index_id = si.index_id
WHERE avg_fragmentation_in_percent > 5
AND index_type_desc <> ‘HEAP’
AND page_count > 100)

SET @Counter = 0

DECLARE DefragCursor CURSOR
FOR SELECT * FROM IndexesToDefrag

OPEN DefragCursor

WHILE @Counter < @NumberOfIndexes
BEGIN
FETCH NEXT FROM DefragCursor INTO @IndexName, @TableName, @Frag
SET @Command = ‘ALTER INDEX ‘ + @IndexName + ‘ ON ‘ + @TableName + ‘ REORGANIZE’ EXEC (@Command) PRINT ‘Executed: ‘ + @command
SET @Counter = @Counter + 1
END

CLOSE DefragCursor
DEALLOCATE DefragCursor

DROP TABLE IndexesToDefrag;

GO

– Round 2 – Rebuild Indexes If Reorganize Was Unsuccessful

SELECT
si.name as IndexName,
OBJECT_NAME(si.object_id) as TableName,
avg_fragmentation_in_percent as Frag
INTO IndexesToDefrag
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, NULL) ips Join sys.indexes si ON ips.object_id = si.object_id AND ips.index_id = si.index_id
WHERE avg_fragmentation_in_percent > 5
AND index_type_desc <> ‘HEAP’
AND page_count > 100;

DECLARE @Command VARCHAR(100)
DECLARE @Counter INT
DECLARE @IndexName VARCHAR(100)
DECLARE @NumberOfIndexes INT
DECLARE @TableName VARCHAR(100)
DECLARE @Frag INT

SET @NumberOfIndexes = (SELECT COUNT(*) FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, NULL) ips
Join sys.indexes si ON ips.object_id = si.object_id
AND ips.index_id = si.index_id
WHERE avg_fragmentation_in_percent > 5
AND index_type_desc <> ‘HEAP’
AND page_count > 100)

SET @Counter = 0

DECLARE DefragCursor CURSOR
FOR SELECT * FROM IndexesToDefrag

OPEN DefragCursor

WHILE @Counter < @NumberOfIndexes
BEGIN
FETCH NEXT FROM DefragCursor INTO @IndexName, @TableName, @Frag
SET @Command = ‘ALTER INDEX ‘ + @IndexName + ‘ ON ‘ + @TableName + ‘ REBUILD’
EXEC (@Command)
PRINT ‘Executed: ‘ + @command
SET @Counter = @Counter + 1
END

CLOSE DefragCursor
DEALLOCATE DefragCursor

DROP TABLE IndexesToDefrag;

While creating a batch script to help automate the restore process I go through fairly often, I somehow created a folder that had around 30 something subdirectories and then a file embedded within that last subdirectory…, OOPS! I could only browse so far, then nothing, I figure probably to the point of 255 characters in the path name (I think the windows os file name limit is 255, not sure, somewhere around there) and then windows (7) would just stop, no error, nothing. Found the error when I tried to delete the folder:

So what do you do? I tried Shift Delete (bypass recycle bin), CMD Prompt: RMDIR /S /Q, with no luck and finally tried Total Commander but still nothing. Finally came across DelinvFile (Delete Invalid Files and Folders). Worked great, google it if you need it, it’s free for 30 days.

If anyone knows how to achieve the same thing without using a 3rd party program, please share, I looked everywhere with no luck. I hate installing a program to do something that should be so simple.

I guess I kind of took a small leap of faith here in ordering a gas engine for my Ultimate Biplane and I say leap of faith because first, I don’t know much about gas engines/models, secondly, I ordered the cheapest engine I could find that was plenty big to power my plane and third, it’s coming from Hong Kong. I ordered a (Turnigy) TGY52, which is their 45cc engine bored out to 52cc. I found the engine at www.HobbyKing.com, check it out, they have great prices on gas engines.

Spec.
Displacement: 52cc
Weight: 1584g
Carburettor: (Japanese Walbro) Diaphragm & Butterfly valve.
Prop Speed: 1700 ~ 7800rpm
Max power: Over 3.2kw
Suggested prop: 20×8, 20×10, 22×8 or larger
Ignition: DC-CD (6v)
Mixture: 25:1 to 40:1
Bore/Stroke: Unknown x 31 mm
Size: 170mm long, 215mm wide, 215mm high (Including baffle)
Mount hole: 64mm x 64mm

Found this neat little trick to change the size of your desktop icons. Hold the Ctrl button on your keyboard and then using the scroll wheel on your mouse, scroll in and out to either make the icons larger or smaller.