News

Microsoft5y

How to configure persistent memory for SQL Server on Linux

SQL Server 2016 introduced support for non-volatile DIMMs and an optimization called Tail of the Log Caching on NVDIMM. These leveraged Windows Server direct access to a persistent memory device in ...
GitHub8y

set-a-maximum-table-size-for-a-trace-table-sql-server-profiler.md

Find out how to limit the size of a trace table. Use SQL Server Profiler to specify the maximum number of rows the table can have. In the Trace name box, type a name for the trace. In the Template ...
GitHub2y

create-a-trace-template-sql-server-profiler.md - GitHub

Discover how to create a new trace template in SQL Server Profiler. Learn how to add filters to the template and how to add or remove events and data columns. In the Trace Template Properties dialog ...
Computer Weekly12y

Microsoft SQL Server data profiling tool put to work

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server.