Tag Archives: State: 2

How to use IIF() in SQL Server ?

SQL Server Denali CTP3 has introduces a new function IIF() to evaluates specified expression and returns specified true/false values. IIF(), is kind of shorthand way of writing a CASE expression where we can expect only two result either true or false. This function is same as available in other languages. IIF(), accepts three parameters, First [...]

SQL Server Transaction Log – Best Practice

Best practices for managing SQL Server Transaction Logs. Steps for better throughput for SQL Server Transaction log. 1. Dedicate a physical disk to your transaction logs.  2.  Defrag the disks on which your tranaction logs reside to get rid of disk file fragmentation.  (requires downtime) 3.  You only need one transaction log.  Put it on a [...]