Pages

Monday, October 23, 2006

[linux] grep, egrep, fgrep - Global Regular Expression Print

grep 一次只能搜索一個指定的模式。
grep [選項] [查找模式] [檔案名1,檔案名2,……]

egrep 檢索擴展的正則運算式(括運算式組和可選項)
egrep [選項] [查找模式] [檔案名1,檔案名2,……]

Friday, May 05, 2006

無法預覽 PSD 縮圖

Support Knowledgebase
Photoshop CS doesn't create thumbnail previews (Windows)
Issue

Adobe Photoshop doesn't create thumbnail previews for images on the desktop or in Windows Explorer.


Solution: View images in the File Browser in Photoshop.

Choose File > Browse to open the Photoshop File Browser and view and open images.


Background information

Previous versions of Photoshop produced thumbnail previews for images by using the psicon.dll file. This file isn't installed with Photoshop CS.


In Windows Explorer, if you choose View > Thumbnails, Windows Explorer displays thumbnail previews for some image formats, such as JPEG files; however, it cannot display thumbnail previews for native Photoshop (PSD) files.
.............................................................
SOLUTIONS:
copy phtoshop 7 dll file: psicon.rar to
C:\Program Files\Common Files\Adobe\SELL\psicon.dll

REGEDIT:


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{0B6DC6EE-C4FD-11d1-819A-00C04FB69B4D}\InProcServer32]
@="C:\\Program Files\\Common Files\\Adobe\\Shell\\PSICON.DLL"
"ThreadingModel"="Apartment"

[HKEY_CLASSES_ROOT\CLSID\{0B6DC6EE-C4FD-11d1-819A-00C04FB69B4D}\InProcServer32]
@="C:\\Program Files\\Common Files\\Adobe\\Shell\\PSICON.DLL"
"ThreadingModel"="Apartment"

[HKEY_CLASSES_ROOT\.psd\ShellEx\{BB2E617C-0920-11d1-9A0B-00C04FC2D6C1}]
@="{0B6DC6EE-C4FD-11d1-819A-00C04FB69B4D}"

Friday, March 10, 2006

SQL - COLLATIONPROPERTY 更改

SELECT COLLATIONPROPERTY('Chinese_Taiwan_Stroke_CI_AS','CodePage') as codepage
SELECT COLLATIONPROPERTY('Chinese_Taiwan_Stroke_CI_AS','LCID') as codepage

SELECT SERVERPROPERTY('collation')
--RebuildM.exe 可以重新修改Server的定序設定

SELECT DATABASEPROPERTYEX(‘xxx’, ‘collation’)
--透過
Alter Database MTF01 Collate Chinese_Taiwan_Stroke_CI_AS
--修改table定序

eng - flock 聚集

KK[flak]
vi. 聚集;成群地


In warm weather, people enjoy water sports. Lovers of surfing, sailing and scuba diving flock to the ocean.

Friday, March 03, 2006

SQL - Shrink Log

--backup transaction log - TRUNCATE ONLY
BACKUP LOG Northwind WITH TRUNCATE_ONLY;


--shrink database - TRUNCATE ONLY
DBCC shrinkdatabase (N'Northwind', TRUNCATEONLY );


--check database status
sp_helpdb @dbname = 'Northwind';


--change database recovery mode - SIMPLE
ALTER DATABASE Northwind
SET RECOVERY
SIMPLE;

Eng - diarrhoea 腹瀉






n. 腹瀉

Many people who travel away from home experience travellers' diarrhoea.

*注意拼法有兩個「r」,「ho」不發音。