Archive for October, 2010

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 В· One Comment
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