Posts in "Database"

13

Jun

2008

Getting error in Enterprise Manager Taskpad view

I continue to get this error whenever i try to use the Taskpad view of adatabase in my SQL Server Entriprise Manager."An...

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...

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...

  • Page 2 of 2
  • <
  • 1
  • 2