dean

dean has asked 0 questions and find answers to 21 problems.

Stats

About

Playing with SQL Server since v.six, been MVP for SQL Server 10 years before joining MS, ex-MCT, ex- local PASS chapter lead, ex-MS, currently an independent contractor working with PostgreSQL on AWS.

Reach me at [email protected] if you feel I can help you beyond SO.

dean questions

dean answers

Use a variable or parameter to specify restart value for ALTER SEQUENCE
FILESTREAM vs VARBINARY for smaller files
Use result of stored procedure inline in SELECT statement
Performance comparison of these two queries
Using 'where then Union' or Using 'Union then Where'
ORDER BY in both queries of the EXCEPT clause
Does SQL Server cache execution plan of a view?
TFS 2013 and SQL Server 2014 Version Conflict
can we use checksum to check that row has been changed(sql server)?
How to update Extended Properties of a Column?