Welcome to Techsapphire

sql server

SQL Complex quries Interview question

Read complete article

SQL for Beginners

SQL (Structured Query Language) It is high level language which provide you capability to query data from any structured data source (Tables).  High level language means language which is used by us to communicate (English).  For learning, we will be using online SQL editor provided by W3C. http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all SQL script: SQL Queries:

Finding expensive queries in SQL Server and performance optimization

Finding expensive queries can be challenging on SQL Server, this tutorial will help you in finding expensive queries on production. Using below DMVs: SYS.DM_EXEC_QUERY_STATS SYS.DM_EXEC_SQL_TEXT SYS.DM_EXEC_CACHED_PLANS SYS.DM_EXEC_TEXT_QUERY_PLAN First is using average logical reads, execution count and total worker time. But still people can use other combinations as well. I have also explained how missing index […]