March 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
decode

How to Decode @@OPTIONS Value? – Interview Question of the Week #268

March 15, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Options, SQL Scripts, SQL Server

The session-level options can be found using the @@options variable in SQL Server. Let us decode that in this blog post and learn about it.

Read More
Case Insensitive

How to Do Case Insensitive Search? – Interview Question of the Week #267

March 8, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Collation, SQL Scripts, SQL Search, SQL Server

Question: How to Do Case Insensitive Search?

Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.

Read More
Two Tables

How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266

March 1, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server

Question: How to Join Two Tables Without Using Join Keywords?

Answer: In my life, I have attended many interviews as an interviewer.

Read More

How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265

February 23, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Question: How to Forecast the Size of Restore of Backup in SQL Server?

Answer: Recently, I had discussed this in consulting engagement:

Read More
resource status

How to Measure Resource Status on Azure? – Interview Question of the Week #264

February 16, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Azure, SQL Performance, SQL Scripts, SQL Server

Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.

Read More
Measure Transactions

How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262

February 2, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Performance, SQL Scripts, SQL Server, SQL Transactions, Windows

Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.

Read More
different methods

What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261

January 26, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Counter, SQL DMV, SQL Scripts, SQL Server, SQL System Table, SSMS

Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.

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

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

Go to mobile version