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

May13

Please Vote for My Session in SQL PASS SQL Server Waits and Queues – Your Gateway to Performance Troubleshooting Session Level: 300 Session Category: Regular Session (75 minutes) Session Track: Enterprise Database Administration and Deployment Just like a horoscope, SQL Server Waits and Queues can reveal your past, explain your…

May12

SQL SERVER – Import CSV File into Database Table Using SSIS

Pinal Dave

SQL Tips and Tricks

CSV, SQL Scripts, SQL Server, SSIS

127

It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server.

May11

SQL SERVER – expressor 3.2 Release Review

Pinal Dave

SQL

expressor, SQL Scripts, SQL Server, SQL Utility

No Comments

I have been following expressor software for some time now and they have recently released a new version of their expressor Studio desktop ETL application. I am pleased to find out that the download and installation experience of this application has been greatly simplified. expressor Studio no longer requires users to install a license key after they download and install the product. They have also eliminated a Microsoft Visio dependency from their product. Removing the license requirement and Visio dependency has made download and installation much easier.

May10

SQL SERVER – Resource Database ID – 32767

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

Earlier I blogged about SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?. After reading the post, I got question by one of the blog reader. “Hi Pinal, I see in your blog post you have Database ID which is 32767. Everytime I want to get the…

May10

SQL SERVER – Common Table Expression (CTE) and Few Observation

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This blog post is written in response to the T-SQL Tuesday hosted by Bob Pusateri. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…

May9

SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…

May8

SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently I was talking with Vinod Kumar regarding NOLOCK. Suddenly he asked me do I know what kind of lock WITH(NOLOCK) hint takes on object. The immediate response of mine was that NOLOCK does not take any lock. He responded suggesting that I should think more and answer. I realized…

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 100 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 – Vote for My Session in SQL PASS

SQL SERVER – Import CSV File into Database Table Using SSIS

SQL SERVER – expressor 3.2 Release Review

SQL SERVER – Resource Database ID – 32767

SQL SERVER – Common Table Expression (CTE) and Few Observation

SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007

SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?

How to Count Week Days Between Two Dates? – Interview Question of the Week #132

Free Webcast – 3 Common Mistakes to Kill SQL Server Performance – My Best Online Presentation

SQL SERVER – FIX: Msg 35250 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed

SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation

SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster

SQL SERVER – How to Identify Columns Used In A View?

SQL SERVER – How to Check if a Column Exists in SQL Server Table?