SQL Interview Questions and Answers Archives - Page 30 of 67

How to Get Random Records from Table? – Interview Question of the Week #105

January 8, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Random, SQL Scripts, SQL Server

Question: How to Get Random Records from Table?

How to Find Number of Times Function Called in SQL Server? – Interview Question of the Week #104

December 25, 2016

Pinal Dave

SQL Interview Questions and Answers

SQL DMV, SQL Function, SQL Scripts, SQL Server, SQL Server 2016

Question: How to Find Number of Times Function Called in SQL Server?

What is Memory Grants Pending in SQL Server? – Interview Question of the Week #103

December 23, 2016

Pinal Dave

SQL Interview Questions and Answers

SQL Memory, SQL Scripts, SQL Server

Question: What is Memory Grants Pending in SQL Server?

How to Use OR Condition in CASE WHEN Statement? – Interview Question of the Week #102

December 18, 2016

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Scripts, SQL Server

Question: How to Use OR condition in CASE WHEN Statement?

Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101

December 11, 2016

Pinal Dave

SQL Interview Questions and Answers

SQL Server, SQL Server Management Studio, SQL System Table, Temporal Table

Question: I just installed SQL Server 2016 developer version and new samples database WideWorldImports, upon expanding the tables, I noticed a special icon on the System-Versioned table which looks like a watch. What does this special icon which looks like a watch represents in SQL Server Management Studio 2016?