Bangalore .Net User Group

Hi Less records it’s nothing for SQL SERVER you can access directly underlying table. As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is...

Primary key A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. This column, or columns, is called the primary key (PK) of the table and enforces the entity integrity of the table. You can create a primary key by defining a PRIMARY...

As said before on the other post, it depends on your application. There are far too may parameters to work with and tuning each of them and getting into a guidance mode will be very difficult. Here is a webcast I did sometime back on handling some of these parameters and what are the options available...

Hello Kiran .. Its a tough task to estimate a hardware for your SQL Server (for that matter any application) empirically before you have it loaded to its full traffic. Here are some tips and hope it helps. - Purchase a medium configuration server ( unless your database is going to take 1000 Trans per...