May 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
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
Get Details

How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275

May 3, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Log, SQL Scripts, SQL Server, SQL Server DBCC

Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.

Read More
Supported Version

What is Transactional Replication Supported Version Matrix? – Interview Question of the Week #274

April 26, 2020
Pinal Dave
SQL Interview Questions and Answers
AlwaysOn, SQL High Availability, SQL Replication, SQL Server

Question: What is the Transactional Replication Supported Version Matrix?

The rules for the supported versions are pretty simple and clearly written.

Read More

How to Import a SQL Server Table Inside Excel Sheet? – Interview Question of the Week #273

April 19, 2020
Pinal Dave
SQL Interview Questions and Answers
Excel, Wizard

Question: How to Import a SQL Server Table Inside Excel Sheet?

Answer: Well, the answer to this question is pretty straight forward and let us see it today. 

Read More
gets full

How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272

April 12, 2020
Pinal Dave
SQL Interview Questions and Answers
File Growth, SQL Error Messages, SQL Log, SQL Scripts

Question: How to Solve Error When Transaction Log Gets Full?

Answer: This was a question I was asked in the recent Health Check.

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

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

Go to mobile version