index – SQL Padawan

SQL Server threads architecture

SQL Server retrieves threads from Windows. The SQL Server configuration setting max worker threads (set at instance level) determines how

What’s a heap table? I would say it’s a table without clustered index. What’s the characteristic of a heap table?

Update data in SQL Server is a simple task. Using the command update table set column = value where column

The most common and widely used index that we know are nonclustered index. These indexes are created using the famous