I have a result set stored in #Results. Now I need to add MORE records to that #Results table. The first query selects all of our employees and stores it in #Results. Now what I want to do is go and ...

I'm looking through a vendor database we purchased and customizing some reports. I'm noticing that ALL their SELECT queries use the hint: WITH NOLOCK. Being as how I do NOT use WITH NOLOCK on all my ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...