Thursday, June 28, 2012

Cannot install MS VC++ Redistributable

Error: "The feature you are trying to use is on a CD-ROM or other removable disk that is not available" Solution: Extract the .exe using WinRAR (don't know if other foftware will work) You'll get the second exe (VCREDI~3.exe, for example) Extract the second .exe and you'll get a .cab and an .msi file Re-run the installer (first .exe) and when it asks for source CD, point it to the extracted .msi

Monday, June 25, 2012

i3 vs i5 vs i7

If you will need to do a lot of zipping of files you are going to see a major improvement by going with ether the i5-2500 or the i7-2600. The i7-2600 is going to earn its keep if you will be working with heavily multithreaded programs like Photoshop and rendering software. (source)

Friday, June 22, 2012

Watchtower Library on Android

WTLib analysis :
I've been trying to find a way to crack that database for a while

JW Helper
- currently supported: [only] english, german

Using HTTrack to create offline version of wol.jw.org:
doesn't work
for example, file 2.html created contains link like this:
"../../../../../../../external.html?link=http://wol.jw.org/id/wol/lv/r25/lp-in/0/494"

Found at Aug 22, 2014:
WTPubs for iSilo Secure File Access
pwd= Wise
contains WTPub 2013

UPDATE (from Urgent Message Please Read.pdf on meekspace):
We have been contacted by the United States Branch and asked to remove all the organizations
publications from meekspace.org and meekspace.com. Although this pains us a great deal to have to do
this we are sure you can appreciate the need to follow the direction of the Branch, Faithful Slave, and
ultimately Jehovah God. After all what good is all the spiritual food in the world if we do not have
Jehovah’s approval?

How to get the watchtower library on your Android device?

Related resources:
Software: AnyBoot (pay)
Software: BOCHS (free)

iSiloX and wol.jw.org

(Windows) OfflineBrowser
...Tried with the following steps but only get few pages:
...1) type starting URL on the left of "Go" button
...2) choose language from dropdown list below it
...3) hit "Download All Pages ..." button
Database (OfflineData.sqlite) is stored in C:\Users\user.sk223\AppData\Roaming\OfflineLibrary_WPF
DB Browser for SQLite
...to get a list of URLs, use "Execute SQL" tab: select URL from PageSearchData

Related
---------
WTL on Linux (PlayOnLinux script):
Watchtower Library 2014

(WTL for Windows) How to find next occurance on search result
Press plus key for next element and minus for previous one

Thursday, June 14, 2012

Execution Plan related

When you enter a stored procedure with CREATE PROCEDURE ..., SQL Server verifies that the code is syntactically correct, ... However, at this point SQL Server does not build any query plan, but merely stores the query text in the database
It is not until a user executes the procedure, that SQL Server creates the plan

[If SQL can't perform parameter-sniffing,] it applies a standard assumption, which for an inequality operation such as > is a 30 % hit-rate

Your application connects with ARITHABORT OFF, but when you run the query in SSMS, ARITHABORT is ON and thus you will not reuse the cache entry that the application uses, but SQL Server will compile the procedure anew, sniffing your current parameter values, and you may get a different plan than from the application

Occasionally, I see people in the forums or the newsgroups that tell me that their stored procedure is slow, but when they run the same query outside the procedure it's fast. After a few posts in the thread, the truth is revealed: the query they are struggling with refer to variables, be that local variables or parameters. To troubleshoot the query on its own, they have replaced the variables with constants. But as we have seen, the resulting stand-alone query is quite different, and SQL Server can make more accurate estimates with constants instead of variables, and therefore arrive at a better plan. Furthermore, SQL Server does not have to consider that the constant may have a different value next time the query is run.

What always works [to troubleshoot a query] is to embed the query in sp_executesql:
EXEC sp_executesql N'-- Some query that refers to @par1', N'@par1 int', <value_of_@par1>

one possible reason that the procedure ran slow in the application was simply a matter of blocking. If you find that no matter how you run the procedure in SSMS, with or without ARITHABORT, the procedure is always fast, blocking is starting to seem a likely explanation.

...

Source:
Slow in the Application, Fast in SSMS?
www.sommarskog.se/query-plan-mysteries.html

Related article:
Analyzing the SQL Server Plan Cache
www.mssqltips.com/sqlservertip/1661/analyzing-the-sql-server-plan-cache/


Examining Query Execution Plans
http://sqlserverpedia.com/wiki/Examining_Query_Execution_Plans

SQL Server Query Execution Plan Analysis
www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

SQLIndex (what is "bookmark lookup)
www.mibuso.com/forum/viewtopic.php?f=34&t=36790&view=previous

Clearing Cache for SQL Server Performance Testing
www.mssqltips.com/tip.asp?tip=1360

Berhubungan dengan kendaraan (Indonesian)

KONSUMSI BAHAN BAKAR (BBM) MOBIL TOYOTA AVANZA

Pompa ban listrik - layak beli ?
Utk memompa ban mobil disaran dongkrak mobilnya lebih dahulu

Memperbaiki Lubang Baut Tap Oli Shogun 125 Yang Doll/Slek
[bila] yang rusak adalah DRAT/ULIR LUBANG BAUT dan bukan pada bautnya. Mengganti baut tidak akan memperbaiki doll/slek-nya dan justru kejadian bocor tetap bisa terulang dan the worst thing baut lepas sehingga oli tumpah habis. Satu-satunya cara adalah membuat ulir/drat yang baru, dalam hal ini memperbesar ukuran bautnya.
...
Sebaiknya membuka baut oli dalam keadaan mesin dingin.
...
Rekomendasi pada saat membuka dengan KUNCI SOK dan saat menutup dengan KUNCI PAS.
...
Kemungkinan yang doll/slek bisa di baut namun sebagian besar terjadi di lubangbaut (yang lebih lunak properti logamnya).

Cara memperbaiki drat lubang baut yang slek, aus, atau dol yang menyebabkan oli rembes atau bocor
jika baut rusak, ganti baud terlebih dahulu, kemudian lilitkan seal tape ( yang biasa dipakai di pipa paralon) pada drat baud, kemudian masukan baud, kencangkan secukupnya.
jika lubang baut yang slek, ganjal drat pake seng, atau kaleng, lilitkan seal tape (yang biasa dipakai di pipa paralon) di drat baut pembuangan oli cukup di bawah kepala baut saja

Oli apa yg bagus buat supra x pgm fi?
DAFTAR HARGA OLI TERBARU 2014

Cara Mudah Merawat Sepeda Motor Bermesin Injeksi

Cara kuras oli
Honda supra injeksi kena banjir?

Setting Langsam Motor Injeksi, Lakukan Dari Mur-Baut Stasioner
Untuk memperbaikinya, Fajar bilang itu gampang. Apalagi modalnya cuma tang lancip untuk mengatur kembali posisi pelat dudukan baut langsam. Tapi biar mudah melakukannya, diwajibkan membuka cover sayap samping kanan agar terlihat lebih lapang.
from: Stasioner Injeksi ( Langsam Kembali Normal)

Dealer Honda belum siap injeksi??

Test Drive Suzuki Hayate 125
+ Shock belakang ganda dan pelek 16 inci berperan banyak dalam mendukung kenyamanan handling. Jok
....lebar semakin menambah kenyamanan pengendara dalam menaklukkan kemacetan lalulintas
+ sangat pas ditunggangi pengendara yang memiliki tinggi badan 175cm
- dek tengah yang sempit membuat kurang nyaman
- Akselerasi awal skutik ini terbilang berat, meski selongsong gas dipuntir secara spontan pergerakannya pun
...tidak seliar yang dibayangkan.

Kenapa harga jual kembali suzuki ancur?
spare part suzuki spare partnya mahal dan susah dicari dan kalau beli maunya paketan. itu yang bikin harga jualnya turun

7 Alasan Mengapa Saya Enggan Meminang Motor Matic Alias Skutik
(penulis artikel ini memilih Yamaha Jupiter Z1)

Modif agar motor lebih nyaman dikendarai:
bikin kontur di jok agar empuk layaknya sofa, ganti shockbreaker yang lebih empuk dan nyaman, pasang raiser setang , ganti ban tubeless biar anti bocor, modif tuas perseneling jungkit jadi injakan
(sumber: Motor harian buat kerja jangan neko-neko)

Tips Cara Test Shock Breaker Motor Sederhana


[ASK] Bingung pilih Honda BeAT, Suzuki NEx, Yamaha Mio-J ?

Mau Beli Bajaj Pulsar? Pikir-Pikir Dulu Deh....

Related sources:
Harga suku cadang Honda
- Knalpot = Muffler exh

Wednesday, June 13, 2012

Gebyar BCA

Pengumuman pemenang

D**** 4681103061
L**** 2581142287

Monday, June 4, 2012

IMAP vs POP3

https://www.facebook.com/note.php?note_id=171551547089