Monthly Archives: June 2013

Table Scans and Index Scans affects more than the table they access

SQL Server only queries data in memory (data cache). If the data needed is not cached, SQL Server will retrieve the data from disk and load it to data cache, and then SQL Server will use the data from the … Continue reading

Posted in SQL Server, Uncategorized | Tagged , | Leave a comment