標籤

2012年6月12日 星期二

MSDASQL 64位元 32位元 使用

I couldn't get the MSDASQL drivers to work, but got a result with the ACE drivers (NOTE I am on 64-bit so using the ACE drivers). It might be that I need the 64 bit version of MSDASQL..... < http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-why-cannot-64-bit-msdasql-access-a-csv-text-file.aspx

SELECT * 
FROM OPENROWSET (
    'Microsoft.ACE.OLEDB.12.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')
If you are on 32-bit, maybe try
SELECT * 
FROM OPENROWSET (
    'Microsoft.Jet.OLEDB.4.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')

使用 DiskSpd 測試磁碟效能

  DiskSpd 是微軟創建的命令行磁碟測試工具。它結合了強大的IO工作負載定義來測量磁碟效能。由於它支援自由配置和調整參數,使其成為存儲效能測試、驗證和基準測試的理想工具。 步驟 1. 從 GitHub (說明) https://github.com/Microsoft/di...