This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Folded and partly opened corn-husk parcels keep rice and vegetables together inside their wrappers

BULK INSERT With FORMAT CSV and FIELDQUOTE for Quoted Files

February 18, 2015
Pinal Dave
SQL Tips and Tricks
CSV, ETL, File format

A comma inside a quoted name can break a CSV load without any error. Here is how FIELDQUOTE fixes it, and how to validate what arrives.

Read More
Gouache painting: a plain cream ribbon unrolled along a short wooden shelf, the ribbon stopping at the shelf edge where one vermilion pin marks the last spot

SQL SERVER – Quiz with DATEADD Function – SQL Puzzle

February 17, 2015
Pinal Dave
SQL Puzzle
SQL DateTime, SQL Function, SQL Scripts, SQL Server

The DATEADD function returns the last day of the month when the day does not exist, so one month after January 31 is February 28. This post keeps the quiz, runs every query on SQL Server 2025 and explains the month rule and the Msg 517 overflow with the real results.

Read More
Uncheck.

SQL SERVER – Installation Error – INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory

February 16, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

SQL Server setup failed saying the INSTALLSHAREDDIR parameter is not valid because the folder is compressed. Here is how removing that attribute fixes it.

Read More
A bookbinding press beside many ordered stacks awaiting work

Interview Question of the Week #007 – How to Reindex Every Table of the Database?

February 15, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Reindex every table selectively with SQL Server catalog checks, quoted identifiers, and a clear choice of rebuild or reorganize.

Read More
SQL SERVER - Msg 8152, Level 16, State 14 - String or Binary Data Would be Truncated

SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

February 14, 2015
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Error Messages, SQL Scripts, SQL Server

Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.

Read More
Warnings for sum and average calculation.

SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation

February 13, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Why does SQL Server warn that Null value is eliminated by an aggregate or other SET operation? I show when it appears and how it can be suppressed.

Read More
Execute Package Task Editor.

SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067

February 12, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS

SSIS expert Andy Leonard covers the basics of the Execute Package Task, how to configure it and how one SSIS package can call another.

Read More
SQL SERVER - Script to Find Leap Year

SQL SERVER – Script to Find Leap Year

February 11, 2015
Pinal Dave
SQL Tips and Tricks

A simple T-SQL script to check whether a year is a leap year, using DATEADD and EOMONTH to find the last day of February for that year.

Read More
SQL SERVER - Error: Fix for Error Msg 3906 - Failed to update database because the database is read-only

SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only

February 10, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Getting Msg 3906, Failed to update database because the database is read-only? The message says it all. Here is how to make the database writable again.

Read More
SQL SERVER - Viewing User Configurable Info in SQL Server

SQL SERVER – Viewing User Configurable Info in SQL Server

February 9, 2015
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A reader asked about sp_user_counter1 to 10 for debugging. I show how sp_trace_generateevent raises events you can watch as User Configurable info.

Read More
Previous 1 … 272 273 274 275 276 277 278 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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