title: How to check if datetime happens to be Saturday or Sunday in SQL Server 2008
body: <p>Given a <code>datetime</code>, is there a way we can know it happens to be a <code>Saturday</code> or <code>Sunday</code>.</p>
  
  <p>Any ideas and suggestions are appreciated!</p>