Browse by Tags

• indexed views
• performance
• query
• SQL Server
• stored procedure
• tsql
• tuning

• Performance Tuning - will I loss the indexing when using derived table?

  This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables can Read More... Posted Tuesday, August 21, 2007 6:19 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, stored procedure, joins, tuning, indexed views

• Join a SQL Server "joins type" - for Newbie

  Since the beginning of learning SQL Server I'm pretty much confused with JOIN conditions that defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign Read More... Posted Tuesday, August 07, 2007 11:52 PM from SSQA.net | (Comments Off) Filed under: SQL Server, tsql, joins