Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)

Al-Farooque Shubho

Rate me:

4.92/5 (176 votes)

1 Jun 2009CPOL26 min read

724.5K

392

As part of a series of articles on data access optimization steps in SQL Server, this article focuses on refactoring and applying TSQL best practices to improve performance.

Revisions

Compare	Revision	Minor	Date	Status	Editor
	26 - publicly available	No	31-Oct-10 6:14	Available	Smitha Nishant

	25	No	1-Jun-09 0:38	Composing

	24	No	1-Jun-09 0:38	Composing

	23	No	26-May-09 17:15	Composing

	22	No	1-May-09 4:17	Composing

	21	No	1-May-09 4:13	Composing

	20	No	27-Apr-09 18:25	Composing

	19	No	27-Apr-09 18:22	Composing

	18	No	23-Apr-09 6:38	Composing

	17	No	20-Apr-09 23:29	Composing

	16	No	20-Apr-09 5:41	Composing

	15	No	20-Apr-09 5:28	Composing

	14	No	19-Apr-09 22:53	Composing

	13	No	19-Apr-09 17:55	Composing

	12	No	19-Apr-09 17:51	Composing

	11	No	19-Apr-09 17:45	Composing

	10	No	19-Apr-09 17:40	Composing

	9	No	19-Apr-09 17:25	Composing

	8	No	19-Apr-09 17:15	Composing

	7	No	19-Apr-09 8:43	Composing

	6	No	19-Apr-09 8:37	Composing

	5	No	19-Apr-09 8:29	Composing

	4	No	19-Apr-09 8:24	Composing

	3	No	19-Apr-09 8:11	Composing

	2	No	19-Apr-09 8:00	Composing

	1	No	19-Apr-09 7:48	Composing

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Al-Farooque Shubho

Founder SmartAspects

Bangladesh

I write codes to make life easier, and that pretty much describes me.

Comments and Discussions

Best overall article of April 2009

Go to top