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
SQL SERVER - Export Data AS CSV from Database Using SQLCMD

SQL SERVER – Export Data AS CSV from Database Using SQLCMD

November 25, 2013
Pinal Dave
SQL Tips and Tricks
CSV, SQL Scripts, SQL Server

We often import CSV into SQL Server, but how do you export data as CSV with SQLCMD? Two simple commands, one with column headers and one without.

Read More
Gouache painting of closed brass elevator doors in a calm lobby, with a single vermilion call button beside them and a potted plant

Elevator Etiquette: Small Rules for a Very Small Room

November 24, 2013
Pinal Dave
Personal
Best Practices, Career Advice, Personal Technology

Elevator etiquette comes down to a few small habits: let people off first, give others room, keep the talk light and stay calm when you miss a door. Here are the rules I follow on conference trips, in office towers and on the way to an interview.

Read More
Backup settings for database restore.

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS

November 23, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Error 3154 says the backup set holds a backup of a different database. Here is how to fix it in SSMS, plus the T-SQL RESTORE WITH REPLACE option.

Read More
Three pale ceramic bowls, two filled with blue and terracotta stones and one empty, beside two loose stones.

XQuery Comparisons: General Equality Is Not Singleton Equality

November 22, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL XML

XQuery Comparisons use different rules for general sequence operators and singleton value operators. I make equality and inequality visible side by side. A general unequal-pair result is not always the inverse of an equal-pair result.

Read More
A man in glasses smiling.

SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003

November 21, 2013
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

Do not blame virtualization for slow servers. David Klee explains how many vCPUs are too many for SQL Server virtualization and how to set them up right.

Read More
A heavily loaded canvas log sling beside a small bundle of kindling

SELECT * Cost: Why Wide Result Sets Slow Exports

November 20, 2013
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Index, SQL Performance

The query starts fast but the export crawls. A small demo shows how much a wide text column adds, and what to measure on your own server.

Read More
A pinsetter deck holds round bowling pins while a square block cannot fit its opening

Edge Constraints: Controlling Which Nodes a Graph Edge Connects

November 19, 2013
Pinal Dave
SQL Tips and Tricks
Schema, SQL Constraint and Keys, SQL Delete

An edge table with no rules accepts nonsense links. Add an edge constraint, watch the bad edge fail, and see what the constraint still does not check.

Read More
A spring catch holds one gate closed while a neighboring gate stays open

A Server Trigger That Blocks Accidental Database Drops

November 18, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Trigger

A server trigger can turn a wrong-tab DROP DATABASE into an error message. Here is a small demo that guards one name and removes itself at the end.

Read More
Illustration for this post

Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device

November 17, 2013
Pinal Dave
SQL Tips and Tricks
Software Development

Finding a box of old floppy disks made me nostalgic. A quick look at the personal storage device, from 1.44 MB floppies to CD, DVD and USB drives.

Read More
Books displayed at a SQL Server book signing.

SQL SERVER – SQLPASS 2013, Charlotte Memories – Book and Book Signing – Part 2

November 16, 2013
Pinal Dave
SQL Tips and Tricks
SQL PASS, SQLAuthority Book Review

SQLPASS 2013 Charlotte memories, part 2: our book signing, where we gave away hundreds of SQL Server books for free, plus a few photos from the event.

Read More
Previous 1 … 320 321 322 323 324 325 326 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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