All Posts by Lori Brown

About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.

May 13

In-Memory OLTP (Hekaton)

By Lori Brown | SQL Administration , SQL Server

Available in SQL Server 2014 Enterprise Edition In-Memory OLTP is a new lock-free, latch-free, optimistic concurrency approach to storing data in memory. While it may seem reminiscent of DBCC PINTABLE is it definitely not the same since data in memory-optimized tables is not organized in pages, and does not use the Buffer Pool. It is […]

May 06

Generate Random Column Values to Populate a Table for Testing

By Lori Brown | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month

Recently I had to do some R&D for a project and needed to generate a large table to test performance on. Since it is important to test queries on large data sets I thought that I would post how I populated a few data types in my table. To test query results I decided that […]

« Previous 1 … 8 9 10