What does "Normal Forms" have to do with selection of FILL_FACTOR and PAD_INDEX settings? What is the value of asking a question, then having several people copy-and-paste the same content, usually directly out of Books Online?...

This scenario makes no sense. When a database restore is done, the restored database should have the same collation as the originally backed-up database. From SQL Server Books Online: http://msdn.microsoft.com/en-us/library/ms190725.aspx > If ...

@vanne040 On your point number 3, you use a "BULK-LOGGED" recovery model all the time? This is not something I've done. According to SQL Server Books Online topic "Considerations for Switching from the Full or Bulk-Logged Recovery Model": > ...

Satya: "There is a huge gap between what is written and what can be achieved in the real world." This architecture is in place all over the world. Every time you book an airline flight or buy something through a service like Amazon, you are experien...

1. "It has been decided to use Failover Clustering...." Failover clustering is a Fault Tolerance solution, NOT a High Availability solution. If it is your only "high availability" solution, it will prevent you from reaching your 99.999% availabilit...

Danny, I have to disagree with both you and Gail Shaw. There is an obvious advantage to having a second log file on a volume that is separate from the first. Since the log files are used sequentially, the second log file will never get used UNTI...

Here's on of the problems with use automated tools that check the differences between DEV and UAT or UAT and PROD, then automagically deploys the differences: There's no gate in between dev and deployment. Prior to deploying any new objects (or ch...

**1. What are the points you would carefully consider when planning the storage for transaction logs?** Others have already addressed storage and RAID. No one has mentioned sizing. All transactions are first written to the transaction log, then ...

rwillemain: The question was how to prevent INSERT/UPDATE/DELETE to a single table, not how to prevent connection to the entire database. What would you do if SELECT were allowed (for example, to support reporting), but INSERT/UPDATE/DELETE were not...

@Malathi Mahadevan: I don't understand your statement "Programming is ideally reserved for application reasons" This would be the enforcement of a business and operational requirement. Why would you want to rely on an outside process (SQL Serve...