(Jay Choe) This article describes how query memory grant works in Microsoft SQL Server. It applies to both SQL2005 and SQL2008.

(Arshad Ali) SQL Server 2016 introduces the temporal table (also known as ‘system-versioned’ temporal table) feature to store history of data changes in a table so that you can travel back in time and get the data that represents a past state in time.

(Chris Webb) When you are using slicers with an Excel PivotTable it’s often useful to be able to get a comma-delimited list of the items selected in that slicer for use in a report title.

(Manoj Pandey) Here we will see how to check the Table level dependencies, means what all Database Objects a Table is related to, like Views, Stored Procedures (SPs), Functions (UDFs), Triggers, etc.

(Paul White) If you use table partitioning with one or more partitions stored on a read-only filegroup, SQL update and delete statements may fail with an error. Of course, this is the expected behaviour if any of the modifications would require writing to a read-only filegroup; however it is also po

(Ahmad Yaseen) Enabling SQL Server Change Data Capture (CDC) will not prevent you from performing DDL changes in your database, but will CDC continue running after DDL changes are made?

(Ryan Adams) One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance or a SQL Server Availability Group) is regarding an incorrect network binding order.

(Greg Larsen) In my last article I introduced you to Dynamic Data Masking:

(Pinal Dave) Before I start explaining the situation, I got into while experimenting with the SQL Server instance on my machine, let me air a word of caution – Please DONOT try this on your production environments. Unless you want to grab unwanted attention from your seniors, this is not something I

(Daniel Farina) In my previous tip about First Steps for SQL Server Performance Troubleshooting I briefly commented on the advantages of this free set of reports. Although you will find other tips about how to install them, in this tip I will show you its features and how to interpret these reports.