Aug 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check

Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119

April 23, 2017
Pinal Dave
SQL Interview Questions and Answers
Connection String, SQL Function, SQL Server, SQL Server Management Studio

Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?

Read More

What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118

April 16, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server, SQL Table Operation

Question: What is the Difference between TRUNCATE and DELETE in SQL Server?

Read More

How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117

April 9, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: How to Change Owner of Database in SQL SERVER?

Read More

How to Find Median in SQL Server? – Interview Question of the Week #116

April 2, 2017
Pinal Dave
SQL Interview Questions and Answers
Ranking Functions, SQL Scripts, SQL Server

Question: How to Find Median in SQL Server?

Read More

What is the Difference between SUSPECT and RECOVERY PENDING? – Interview Question of the Week #114

March 26, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Server, Starting SQL

Question: What is the Difference between SUSPECT and RECOVERY PENDING?

Read More

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115

March 19, 2017
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL DMV, SQL Scripts, SQL Server

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan?

Read More

How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113

March 12, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Backup, SQL Restore, SQL Scripts, SQL Server

QHow to Get Status of Running Backup and Restore in SQL Server?

Read More
Previous 1 … 25 26 27 28 29 30 31 … 67 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com