This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Two complementary ceramic parts form one complete pouring vessel

How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285

July 12, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Question: How to Combine Time and Date in SQL SERVER?

Answer: A very simple and popular question. Let us learn together.

Read More
Illustration for the Open Source Cloud series

What are the Different Layers of Open Source Cloud?

July 5, 2020
Pinal Dave
SQL Interview Questions and Answers
AWS, Cloud Computing, SQL Azure

What are the different layers of open source cloud? A beginner friendly map from hardware to apps, with open source tools for each layer.

Read More
An open travel case and the ceramic jug it must actually hold

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 and 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
Dark and light stones occupy two recesses while a third recess is empty

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
A fixed rail guides a cart along a winding route despite a shorter path

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
Two matching doors belong to one building

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 Data Storage, SQL Scripts, SQL Server

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

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

Read More
A woven panel and a complete replacement with an additional stripe

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
Previous 1 2 3 4 5 6 7 … 58 Next
  • Books
  • Testimonials
  • Privacy Policy

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