Articles

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.

2019-06-19 (first published: )

55,467 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

2019-06-12 (first published: )

119,575 reads

Blogs

Cool Stuff in Snowflake – Part 9: ILIKE

By

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...

Scalar Valued Functions in SQL Server 2019

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

credentials running powershell monitoring scripts

By kevin.j.sexton

I have about 5 or 6 powershell scripts I use to monitor 300 SQL...

An Alert Philosophy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Alert Philosophy

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers