SQL Interview Questions and Answers Archives - Page 16 of 67

How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201

November 25, 2018

SQL FileGroup, SQL Scripts, SQL Server, SQL TempDB, TraceFlags

Question: How to Grow All Files in a File Group Equally?

Answer: If you are a regular reader of this blog, you would have read my earlier blog post writing about this subject over here: SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags. However, let us try to get an answer to our question in this blog.

How to Trim TIME Part in DATETIME Values? – Interview Question of the Week #200

November 18, 2018

Pinal Dave

SQL Interview Questions and Answers

SQL DateTime, SQL Function, SQL Server, SQL String

Question: How to Trim TIME Part in DATETIME Values?

Does Sort Order in Index Column Matters for Performance? – Interview Question of the Week #199

November 11, 2018

Pinal Dave

SQL Interview Questions and Answers

Execution Plan, SQL Index, SQL Performance, SQL Server, SQL Statistics

Question: Does Sort Order in Index Column Matters for Performance?

Answer: Wow, it has been a long time since I have heard this question and the matter of fact, I have never blogged about this subject on this blog. I have received this question during my recent Comprehensive Database Performance Health Check.

How to Find Size of the Index for Tables? – Interview Question of the Week #198

November 4, 2018

Pinal Dave

SQL Interview Questions and Answers

SQL DMV, SQL Index, SQL Scripts, SQL Server

Question: How to Find Size of the Index for Tables?

Answer: Earlier this week, during the Comprehensive Database Performance Health Check, I was asked this question by my client. Let us see the script which will give us details related to Schema, Tables, Index and its size.