Julien Vavasseur questions

Julien Vavasseur answers

• How to do a PIVOT by day cycle in 31 days in month in SQL Server
• Is it possible to force SQL Server to use the plan I want to optimise recursive cte query
• CTE,Temp table and table variable
• Error after disable Index in a table
• How to Partition a Table by Month ("Both" YEAR & MONTH) and create monthly partitions automatically?
• Default value is GUID in SQL Server table column
• SQL Server 08 - pivot - Change Column Name
• Should I set ARITHABORT in SQL Server 2014