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
Gouache painting of mixed tiles travelling down wooden channels into organized rows in a sorting tray.

Importing CSV File into SQL Server: SQL in Sixty Seconds #018

June 20, 2012
Pinal Dave
SQL Video
CSV, File format, SQL in Sixty Seconds, SQL Scripts

Importing CSV file data into SQL Server means matching the file to a table, loading it and checking the result. The tests here show a bad row skipped after a printed error, a text staging load, and the encoding and line ending settings that break a load.

Read More
SQL Server role mappings.

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Security

A friend could connect to SQL Server but could not see any user created object, while his colleague could. It was a security and permissions issue.

Read More
CREATE TABLE in SQL Server.

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

June 18, 2012
Pinal Dave
SQL Puzzle
SQL Server Management Studio

Madhivanan asked how to tell if a table has a uniqueidentifier column without querying system tables or DMVs, knowing only the table name.

Read More
SQL Server Auto-Load Changes.

SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)

June 17, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Open a read only file in SSMS and you get a small lock icon. You can edit it, but saving brings a pop-up. Here is how SSMS handles read only files.

Read More
SOUNDEX Function results with SQL Authority.

SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function

June 16, 2012
Pinal Dave
SQL Puzzle

A reader’s swap puzzle solution used SOUNDEX, so many asked how it works. I explain the SOUNDEX function and DIFFERENCE function with simple examples.

Read More
A small wooden card organizer holding plain blank dividers beside a closed notebook on a desk.

Building a Reference You Will Actually Use Again

June 15, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.

Read More
SQL SERVER - Solution of Puzzle - Swap Value of Column Without Case Statement

SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement

June 14, 2012
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts

Readers sent more than 50 answers to my swap puzzle. Here are 5 different ones that swap a column value without CASE statement, plus my own three.

Read More
SQL SERVER - Video - Beginning Performance Tuning with SQL Server Execution Plan

SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan

June 13, 2012
Pinal Dave
SQL Performance
Execution Plan, SQL Server

Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.

Read More
SQL SERVER - A Quick Look at Logging and Ideas around Logging

SQL SERVER – A Quick Look at Logging and Ideas around Logging

June 12, 2012
Pinal Dave
SQL Performance

What comes to mind when you hear logging? I asked five SQL Server friends and got five answers, from the OUTPUT clause on. Here are our ideas around logging.

Read More
A row of identical lifebuoy rings hung on posts along a wooden harbor pier, the nearest one vermilion.

An Error Handling Template for Stored Procedures With THROW

June 11, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Error Messages, SQL Server, SQL Stored Procedure, SQL Transactions

Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.

Read More
Previous 1 … 374 375 376 377 378 379 380 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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