9 best practices for faster SQL queries. Retrieve only the columns you need; ... SQL Server Enterprise offers “partitioning,” which allows you to split database tables into multiple partitions.