July 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
replace STAR

SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130

October 7, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Server, SQL Server Management Studio, SSMS

You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.

Read More

Cycle Clipboard Ring – SQL in Sixty Seconds #129

October 6, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SQL Shortcut, SSMS

Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. In SQL Server it is totally possible to use the Cycle Clipboard Ring.

Read More
statistics IO

SET STATISTICS IO ON – SQL in Sixty Seconds #128

October 5, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.

Read More

Performance Comparison – IN vs BETWEEN – SQL in Sixty Seconds #127

October 2, 2020
Pinal Dave
SQL Video
SQL Comparison, SQL in Sixty Seconds, SQL Operator, SQL Scripts, SQL Server

Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.

Read More
non-English

Varchar vs Nvarchar – Storing Non-English Characters – SQL in Sixty Seconds #126

September 29, 2020
Pinal Dave
SQL Video
SQL Datatype, SQL in Sixty Seconds, SQL String

Let us learn how to store non-English Characters in SQL Server tables. You will learn in this video the major difference between VARCHAR and NVARCHAR.

Read More
nested transaction

Nested Transactions are Myth – SQL in Sixty Seconds #125

September 25, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server, SQL Transactions

Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post. 

Read More
Temp Table in

Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124

September 22, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure, SQL TempDB, Temp Table

Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.

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

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

Go to mobile version