Posts tagged "Programming"

11

Jun

2008

Generating Random Number and String in C#

The following code returns a random number between min and max: private int RandomNumber(int min, int max) { ...

26

May

2008

MS SQL SERVER – Shrinking Truncate Log File (Log Full)

Is it impossible to shrink the Trucated Log file? Yes, following code always shrinks the Trucated Log File to minimum...

08

Apr

2008

DELETE and TRUNCATE in Database

DELETE logs the data for each row affected by the statement in the transaction log and physically removes the row from the...

02

Apr

2008

Overhead in mysql

Every database will, over time, require some form of maintenance to keep it at an *optimal* performance level. Purging deleted...

31

Mar

2008

Minimizing Deadlocks

Although deadlocks cannot be completely avoided, following certain coding conventions can minimize the chance of generating...

31

Mar

2008

Reducing SQL Server Deadlocks

By: Brad McGehee Deadlocking occurs when two user processes have locks on separate objects and each process is trying to...