What Permissions does QUERYTRACEON Need?
9 Comments
The QUERYTRACEON hint can be particularly useful for testing the new cardinality estimator in SQL Server 2014 on individual queries using Trace Flag 2312, if your database is still using compatibility level 110: Transact-SQL SELECT ClosedDate, Id FROM dbo.Posts WHERE LastActivityDate > '2013-09-05 11:57:38.690' OPTION (QUERYTRACEON 2312); GO 12345 SELECT ClosedDate, IdFROM dbo.PostsWHERE LastActivityDate > '2013-09-05…
Read More