Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
What are Forwarded Records in SQL Server? – Interview Question of the Week #145
Question: What are Forwarded Records in SQL Server?
Answer: It is interesting to see this question keeps on coming up in the interview questions. Even though this is very old concept, I hardly see new DBAs know about this subject.
Let us see the answer the question about the forwarded records.
SQL SERVER – Unable to Bring SQL Online – DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot
Here is one of email which I received from one of my clients where he mentioned that he was unable to bring SQL Online.
Pinal,
I need assistance in getting the failed SQL Server resource online on the node named “SQLDBN01” for the Cluster named “DBCLUSTER01 “.
I checked the event log and have all generic messages. Do you have any expert trick?
Thanks!
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
I have been writing a lot of my findings with SQL Server 2016 in the recent past. This is also being something I have been investing big time keeping my session at SQLPASS coming in the October timeframe. I will be talking on a number of capabilities and enhancements around SQL Server 2016 from a performance standpoint that it is critical for me to explore some. I invest considerable time in preparation for any session and every single year going to SQLPASS has been the highlight and most of the time it is about hard work to make sure everyone attending my session gets the best of content. Also, it is a great way for me to do due diligence and homework as I prepare with real world problem statement with possible alternatives and solutions as part of my session. Let us learn about Creating Clustered ColumnStore with InMemory OLTP Tables.
Does Dropping Primary Key Drop Non-Clustered Index on the Column? – Interview Question of the Week #085
Question: When we drop primary key on the column, does it automatically drop a non-clustered index on the same column (if created)?
Before we see answer of this question, I suggest you read following three blog posts, they discuss various similar aspects related to the primary key and clustered index.
How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084
Question: How to drop clustered index, which is created on primary key?
Answer: If you thought the answer as simple as following script, you are wrong.
DROP INDEX PK_Table1_Col1
ON Table1
GO
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Question: When we drop clustered index on the column, does it automatically drop primary key on the same column (if created)?