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’t… Read more