How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can ...

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some ...

It really is going to come down to how many nonclustered indexes you have on the table, how many transactions per second are writing to the table and how the SQL Server's storage is configured.

9 best practices for faster SQL queries Retrieve only the columns you need Use CASE instead of UPDATE for conditional column updates Keep large-table queries to a minimum Pre-stage your data ...

In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

SELECT * FROM SalesHistory Considerations SQL Server 2008’s table parameter feature is a huge step forward in terms of development and potentially performance.

Inserts made by other users are not visible (inserts cannot be made through a Transact-SQL server cursor). If a row is deleted, an attempt to fetch the row returns an @@FETCH_STATUS of -2.