Blog Home Page - Page 355 of 829 - SQL Authority with Pinal Dave

Jul6

You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table? Suppose you want to create a data set with two columns named a and b SELECT…

Jul5

Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space

Pinal Dave

SQL Interview Questions and Answers

SQL Performance, SQL Scripts, SQL Server, SQL TempDB

Here is one of the important interview question which is related to TempDB and how to Move TempDB from One Drive to Another Drive When Low Disk Space.

Jul4

SQL SERVER – Secure by Default – The Mantra

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

No Comments

Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I don’t disappoint the requests because they give me an opportunity to learn something new too. Last month when I visited Sri Lanka for the first ever SQLSaturday event,…

Jul3

SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Transaction Isolation

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. I have seen many DBAs getting confused between these two terms because both of them…

Jul2

SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087

Pinal Dave

SQL

Notes from the Field, SQL CPU, SQL Server

[Note from Pinal]: This is an 87th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. He is always looking for an opportunity to improve the life of DBAs and Developers. Let us learn about Disabled CPU Power Saving.

Jul1

SQL SERVER – Steps to Generate Windows Cluster Log?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Log

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. It is tough to learn everything all by ourselves, so learning is best done by sharing. There are many incidents with SQL cluster…

Jun30

SQL SERVER – Knowing the Source Application Using APP_NAME() Function

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

APP_NAME() function in SQL Server returns the application name of the current session in which it is called. When you execute the following code SELECT APP_NAME() AS application_name You get the following result application_name ———————————————- Microsoft SQL Server Management Studio – Query This function can be effectively used to audit…

SQLAuthority News - Presenting 3 Technical Sessions at Great Indian Developer Summit - May 7, 2013 - Bangalore unionallvsunion-800x358

SQL SERVER – UNION ALL and UNION are Different Operation

SQL SERVER – Weekly Series – Memory Lane – #026

SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database

SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement

SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course

SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table

Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space

SQL SERVER – Secure by Default – The Mantra

SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level

SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087

SQL SERVER – Steps to Generate Windows Cluster Log?

SQL SERVER – Knowing the Source Application Using APP_NAME() Function

SQL SERVER – UNION ALL and UNION are Different Operation

SQL SERVER – Weekly Series – Memory Lane – #026

SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database

SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement

SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course

SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore