http://dot-net.shareknowledges.com/166/section-Home/Dot-Net-KB.aspx/category/4 home en-US Thu, 04 Dec 2008 23:59:48 GMT Thu, 04 Dec 2008 23:59:48 GMT Cuyahoga Website Framework 60 http://dot-net.shareknowledges.com/166/section-Home/Dot-Net-KB.aspx/20 When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables. Each of the four table options has its own purpose and use, and each has its benefits and issues: Normal tables... FengLiN Mon, 12 May 2008 08:13:12 GMT Database http://dot-net.shareknowledges.com/166/section-Home/Dot-Net-KB.aspx/16 Below is my list of the top 15 things I believe developers should do as a matter of course to tune performance when coding. These are the low hanging fruit of SQL Server performance – they are easy to do and often have a substantial impact. Doing these won’t guarantee lightening fast performance, but it won’t be slow either. Create a primary key on each table you create and unless you are really knowledgeable enough to... FengLiN Tue, 06 May 2008 02:23:22 GMT Database