June 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
open SSMS

SQL SERVER – Open SSMS from Command Prompt

June 15, 2020
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Command, SQL Server Management Studio, SSMS

Recently one of my clients asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.

Read More
Explain SQL Server Execution Plan

Azure Data Studio – Explain SQL Server Execution Plan

June 13, 2020
Pinal Dave
SQL Tips and Tricks
Azure Data Studio, Execution Plan, SQL Server Management Studio, SSMS

The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio. Comprehensive Database Performance Health Check.

Read More
queryJSON

Azure Data Studio- Export Any SQL SERVER Query As JSON

June 12, 2020
Pinal Dave
SQL Tips and Tricks
ADS Notebook, Azure Data Studio, JSON, SQL Server Management Studio, SSMS

Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.

Read More
Just Log File

SQL SERVER – Restore Database With Just Log File

June 6, 2020
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server, SQL Server Security, SSMS

Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. It is not possible.

Read More
any data

SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information

May 26, 2020
Pinal Dave
SQL Tips and Tricks
Schema, SQL Reports, SQL Scripts, SQL Server, SQL Server Configuration, SSMS

If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.

Read More
non-clustered-primary-key0

SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention Changing Primary Key to Non-Clustered

May 11, 2020
Pinal Dave
SQL Performance
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Wait Stats, SSMS, Stress Testing

You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.

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 … 6 7 8 9 10 11 12 … 26 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version