Archive for the ‘Tech’ Category
MSSQL TODAY Function
DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0) roughly twice as efficient as: CONVERT(DATETIME, CONVERT(varchar(10),@time, 120))
October 27, 2010
В·
admin В·
No Comments
Posted in: MSSQL
SET STATISTICS IO
Profiling the cost of each query: SET STATISTICS IO { ON | OFF } via SET STATISTICS IO. Also, http://msdn.microsoft.com/en-us/library/ff647793.aspx
October 24, 2010
В·
admin В·
No Comments
Posted in: MSSQL