Too many validations to be done for each record before making a posting. Server is also too busy. Cursor in my application is unavoidable.

I've tuned the code, to complete the...

I know, cursors are DON'T GO THERE!! area in SQL Server.

I've 2500 records of financial postings to be done in production server. Each record has to be validated for account code,...

Hi,

For large tables like that of yours, it is better to place table in one filegroup, place indexes in other filegroup on DIFFERENT PHYSICAL DISK ARRAYS. SQL server can access...

Hi Robert,

Though 1.5 times the amount of physical RAM is recommended, maximum allowed size for any one instance of pagefile.sys on a machine is limited to 4GB. So, you can...

Hi JK,

To check the performance of the Sproc/Statement using duration, first ensure that the server load does not fluctuates heavily. If possible try being a single user.

You can take the...