boydc7 questions

boydc7 answers

• Why do we need secondary data files in SQL Server?
• Function call in where clause
• Why Would An Outer Join Be Slower Than Separate Queries
• Access SQL query: find the row with the most recent date for each distinct entry in a table
• Joining tables based on the maximum value
• SQL Server slow select from large table
• SQL error: String or binary data would be truncated
• Giving precedence/weight to a column using FREETEXTTABLE
• sql server execute as permission errors in trigger
• SQL conflicted with the FOREIGN KEY constraint