How do I make SQL Server go faster?
This is the most frequently asked question about SQL Server. The answer is a combination of good database design, an effective indexing strategy and efficient T-SQL queries. We can assist in all of these.
However you're working, we can help in creating a good table design to meet your needs.
All of the above are important considerations, but the main thing to remember is that setting up indexes is usually a compromise. Simply put, the more indexes you add, the more queries you can speed up, but you will also put more of a load on your INSERTs, UPDATEs and DELETEs. We can help you find the right balance.
Are your queries SARGable?
Do you know about the Curse and Blessings of Dynamic SQL, how it can be powerful, but potentially a security risk?
Perhaps most importantly, are you thinking in sets?