Sep 2025 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

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

Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112

March 5, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Configuration, SQL Server Services

Question: Why to Use SQL Server Configuration Manager Over Services applet (services.msc)?

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

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

Go to mobile version