In this article we will evaluate the Performance Impact of searching data in SQL Tables. We will understand how the Query Optimizer processes such queries and things we need to be aware of, from a performance standpoint, by using any toolset.
In this article, we will go through one of the features in SSMS 2016 – ‘Quick Launch’. Quick Launch greatly helps in making the developers productive in the IDE by helping them to search features and options inside SSMS.
On 15th October, 2016 I attended the Atlanta Code Camp held at the Kennesaw State University, Marietta, GA. I was quite humbled to get an opportunity to be a speaker this year and presented in the Database Development category on ‘Making developers lives easier with SQL Server 2016’.
Since the initial release of SQL Server 2016 in May 2016, there has been monthly updates to SSMS which includes enhancements, new features and bug fixes. This has been a big step in ensuring that the SSMS IDE is up to date and provides a superlative user experience. But how do you know that a new version of SSMS has been released?
SSMS does not provide any tools/utility to search for a value/data inside a particular database.This kind of surprises me a bit, since it is a needed functionality and would be a very popular feature to be built into the SSMS IDE. So the question is, how do you search for a particular value/data in your SQL Database?