Recently, I had a problem about slow queries. Table index was a first cause of slow queries; however, the problem was still exists after adding the indexing. Using SQL Server Profiler to trace the queries, there was some queries seem like confused. The column was Varchar but the query use Nvarchar. Therefore, the query didn’tContinue reading “Microsoft JDBC Driver for SQL Server連線設定可能碰到的資料型態問題”
