Question: How to List Queries With Memory Grant and Execution Plan?
Earlier I wrote a blog about DBA doing detective work. SQL SERVER – Why We have an Audit, Trace in DATA Folder? What are These Files?. Now today there is another similar situation where the account is added automatically in SQL Server used by SharePoint.
Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have a blog about data-warehouse database WideWorldImportersDW. In this blog we would learn about how to install database WideWorldImportersDW.bak
How to List All ColumnStore Index with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Index with Table Name in SQL Server?
SQL Server 2017 has been released for a while. I have been using it for a while and it is a pretty stable release from Microsoft.