ahains questions

ahains answers

• SQL Server Non-Standard Date Based Histogram
• Apache Hive regEx serde: data types
• SQL Dynamic DatePart when using DateDiff
• SQL Server, where clauses comparisons with different types & default casting behaviour
• Does CHECKPOINT work the same as COMMIT in TSQL?
• Selecting the top n rows within a group by clause
• When are shared read locks released?
• SQL Server Index - Any improvement for LIKE queries?
• add SQL Server index but how to recompile only affected stored procedures?