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

SQL SERVER – Difference Between Count and Count_Big

April 29, 2021
Pinal Dave
SQL Tips and Tricks
Data Type, SQL Scripts, SQL Server

Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.

Read More
learning resources

Learning Resources I Use and Recommend (Updated: April 2020)

April 27, 2021
Pinal Dave
SQL Tips and Tricks
Instant Learning

In today’s blog post I will be sharing a few of the learning resources which I have been using to further train my skills. 

Read More
Greenbox Around Icon

Android Greenbox Around Icon – Unable to Scroll

April 23, 2021
Pinal Dave
SQL Tips and Tricks
Android

I thought it might be just a temporary thing and I had restarted it but that was not the case. In My android phone, I had a Greenbox Around Icon.

Read More
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
python3

Install Python3 on Linux

April 21, 2021
Pinal Dave
SQL Tips and Tricks
Kali Linux, Linux, Python

My major focus is always on SQL Server. I know a little bit about other technology as well. It is very straightforward to install Python3 on Linux.

Read More
change password

SQL SERVER – Change Password at the First Login

April 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.

Read More
adhoc queries

SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads

April 16, 2021
Pinal Dave
SQL Tips and Tricks
Ad Hoc Query, SQL CPU, SQL Scripts, SQL Server, SQL Server Configuration

Discussion with a client during the Comprehensive Database Performance Health Check.  The topic is AdHoc Queries and Optimize for Adhoc Workloads.

Read More
Previous 1 … 9 10 11 12 13 14 15 … 526 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version