Feb 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
Verify Backup

What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283

June 28, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.

Read More
BIT Datatype

Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282

June 21, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Datatype, SQL Scripts, SQL Server

Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?

Answer: Very interesting question. Let us learn about it today.

Read More
force index

How to Force Index on a SQL Server Query? – Interview Question of the Week #281

June 14, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, Query Hint, SQL Index, SQL Scripts, SQL Server

Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.

Read More
Extension MDF

Can a Database Have Multiple Files with Extension MDF? – Interview Question of the Week #279

May 31, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Files

Question: Can a Database Have Multiple Files with Extension MDF?

Answer: Yes. It is possible to have multiple files with extension MDF.

Read More
AddNewColumns

How to Alter Index to Add New Columns in SQL Server? – Interview Question of the Week #278

May 24, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts, SQL Server

Question: How to Alter Index to Add New Columns in SQL Server? 

Answer: It is not possible to Alter Index definition to add or remove columns.

Read More
speed

How to Know Backup Speed in SQL Server? – Interview Question of the Week #277

May 17, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Question: How to Know Backup Speed in SQL Server?

Answer: It is very simple to know the backup speed in SQL Server. Let us discuss today.

Read More
2019

Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276

May 10, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Download, SQL Sample Database, SQL Server, SQL Server 2019, SQL Server Management Studio, SSMS

Question: Where to Download SQL Server 2019 for FREE?

Answer: This is one of the most popular questions, I keep on receiving from blog readers.

Read More
Previous 1 2 3 4 5 6 7 … 67 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version