Ref: http://yhlin.tw/?p=69

Solution:
把所有和該 Table 相關的 Join 改為 Left Join 或 Right Join, 以告知 SQL Server 該 Table 所有的資料都會被選出來, 這樣 SQL 就會使用該 Table 的 Index 了.

1. 修改 Maintenance Plan 的 Connection(上方有一個 Manage Connections)

2. 修改 SQL Server Agent 中的相對應的 Job (我是改成 sa)

Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

Right-click the server (local computer) tree, where server (local computer) is the name of your IIS server, and then click Properties.

Click MIME Types.

Scroll down the registered MIME type list to find the .zip entry.

Click the .zip application/x-zip-compressed entry, and then click Edit.

Change the MIME type value to application/octet-stream.

Stop and then restart the IIS Admin Service to apply the change to the MIME type.

參考: http://blog.darkthread.net/blogs/darkthreadtw/archive/2009/02/11/4186.aspx

1. 安裝 ActivePerl 的版本 (目前要安裝 x86 的版本, 因為 x64 不支援 isapi)
   1. Windows 2008  (x64)
      1. Install ActivePerl from http://www.activestate.com/activeperl/. At this time, there is a link to version 5.10 for Windows (x86) on this page. This link downloads an MSI installer to your machine which you can run.
      2. If you are running the 64 bit version of Windows 2008, ensure that your application pool is configured to run as 32 bit. Assuming that you will be using ActivePerl in the default application pool, these steps will do it:
         1. From the Windows ‘Start’ menu, pick run and type “inetmgr” (without the quotes). Click on ‘OK”.
         2. In the left hand pane of IIS Manager, open up the settings for your server. Click on “Application Pools”.
         3. In the Application Pools page, select “DefaultAppPool”.
         4. In the right hand pane, under “Edit Application Pool”, click on “Advance Settings…”
         5. In the Advanced Settings dialog, ensure that “Enable 32-bit Applications” is set to “True”.
      3. Create a handler mapping that associates “*.pl” requests with ActiveState’s perlex30.dll extension using the following steps:
      4. In the left hand pane of IIS Manager, select your server. This will apply the following handler mappings on the entire server. If you would like to do this for just a specific site or application, you can open up the server and select any site or application. In the center pane, double click on the Handler Mappings icon.
      5. When the Handler Mappings pane is displayed, click on the “Add Module Mapping…” item in the Actions pane on the right.
      6. Fill out the Add Module Mapping dialog as follows:
         1. For Request Path, enter “*.pl”.
         2. For Module, select “IsapiModule” from the dropdown list. Note that the ISAPI module is a prerequisite. If it does not show up on this list, it will need to be installed an an IIS optional component.
         3. For Executable, enter “c:\perl\bin\PerlEx30.dll” (without the quotes.) Note that this assumes that you’ve installed ActiveState Perl using its default location. If you installed it in another location, you will need to look there for perlex30.dll.
         4. For Name, enter “ActiveState Perl for .pl”. Note that this name is just a label and does not affect functionality. It does need to be unique, though. If you are going to be associating other file extensions with ActiveState Perl, the names for those mappings will need to be different.
      7. You do not need to do anything with the “Request Restrictions…” button. If you wish to limit this mapping to specific HTTP verbs, etc., it can be done there.
         Repeat the above steps for any additional file extensions you wish to be associated with Perl. On IIS 6, ActiveState Perl creates mappings for “*.pl”, “*.plx” and “*.plex”. Additionally, some applications are known to map “*.cgi” with Perl.

   http://blogs.iis.net/wadeh/archive/2009/04/13/running-perl-on-iis-7.aspx

   2. Windows 2003 的 IIS 6 的設定: http://www.visualwin.com/Perl/
      1. In that window, where it asks for the extension name you can put anything, like “CGI script” and under the “Required Files” section put the following in (without the apostrophes) ‘C:\Perl\bin\perl.exe “%s” %s’ click OK to the notification, click “Set status to allowed” and press ok.
      2. 網站要允許 Script 和 Isapi
      3. 設定 .pl 的對應
         在 主目錄 > 應用程式的設定中, 新增 .pl 的設定
         執行檔: C:\Perl\bin\perl.exe “%s” %s
         附檔名: .pl
   3. 國家反查
      在 Dos 指令下執行:
      ppm install Geo::IP::PurePerl
      ppm install Geography::Countries
      ppm install IP::Country
   4. 下載 http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz (原文的下載點有問題)把
      GeoIP.dat 解壓縮至 C:\Perl 目錄下

http://www.activestate.com/activeperl/
G:\Software\ActivePerl-5.10.1.1007-MSWin32-x86-291969.msi

2. 安裝 Awstats:
   1. 參考: http://www.pgs-soft.com/wp-content/uploads/2010/03/InstallingAWStatsOnIIS6_IIS7.pdf (G:\Software\InstallingAWStatsOnIIS6_IIS7.pdf)
   2. 下載: http://awstats.sourceforge.net/#DOWNLOAD
      G:\Software\awstats-6.95.exe
   3. 自動的設定程序中, 可以新增一個設定檔
   4. 讀取前一天的 LOG:
      LogFile=”G:/Log/W3SVC2/u_ex%YY-24%MM-24%DD-24.log”, 設定自動執行的時間在早上 8:30
   5. LogFormat 要改為 2, 可參考 C:\Program Files (x86)\AWStats\docs\awstats_setup.html
      一定要把格式改掉, 因為原來的 Log 沒有記錄發送和接收的 bytes 數
   6. 修改/etc/awstats/awstats.yourdomain.conf
      DNSlookup=0
      LoadPlugin=”geoip GEOIP_STANDARD C:/Perl/GeoIP.dat”
   7. Awstats亂碼的的解決方法
      請加入LoadPlugin=”decodeutfkeys”
      這行儲存即可正常顯示中文
   8. 更改時區
      LoadPlugin=”timezone +8″

參考
http://blog.miniasp.com/post/2007/11/How-to-install-AWStats-traffic-statistics-software-in-Windows.aspx

加入以下的Javascript(其中taiwan.js是有台灣地區縣市資料的array)

1
2
3

<script src="jquery.js" type="text/javascript"><!--mce:0--></script>
<script src="taiwan.js" type="text/javascript"><!--mce:1--></script>
<script src="jquery-area-select.js" type="text/javascript"><!--mce:2--></script>

在想要加入下拉式選單的區域如下加入taiwan-select這個class的div
如下

1
2
3

$(document).ready(function(){
	$(".taiwan-select").html(createCounty('yourIdTitle'))
})

所產生的動態下拉式選單name和Id屬性的命名為下面規則
County: yourIdTitleCounty
Zone:yourIdTitleZone
Zip:yourIdTitleZip

Substr
myVar = substr2(myVar, x, y); //Your function
myVar = myVar.substr(x, y); //built-in function

Trim
String.prototype.trim = function(){return
(this.replace(/^[\s\xA0]+/, “”).replace(/[\s\xA0]+$/, “”))}

startsWith
String.prototype.startsWith = function(str)
{return (this.match(“^”+str)==str)}

 endsWith
String.prototype.endsWith = function(str)
{return (this.match(str+”$”)==str)} 

Examples:
var myStr = “  Earth is a beautiful planet  ”;
var myStr2 = myStr.trim();  
//==“Earth is a beautiful planet”;

if (myStr2.startsWith(“Earth”)) // returns TRUE

if (myStr2.endsWith(“planet”)) // returns TRUE

if (myStr.startsWith(“Earth”))
// returns FALSE due to the leading spaces…

if (myStr.endsWith(“planet”))
// returns FALSE due to trailing spaces…

參考連結: http://www.tek-tips.com/faqs.cfm?fid=6620

加入

1

<script type="text/javascript" src="yourpath/jquery-gallary.js"></script>

將圖片外的標籤加上 class=”gallary”
就會把裡頭的所有圖片用fadeIn & fadeOut撥放

1
2
3
4
5
6

<div class="gallary">
<img src="yourimg1"/>
<img src="yourimg2"/>
<img src="yourimg3"/>
<img src="yourimg4"/>
</div>