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 backups and restores.

SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward

March 21, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts

A reader restored a full backup, then hit Error 3117: the log or differential backup cannot be restored. Here is why it happens and what to do.

Read More
Two hands at a relay baton exchange on a running track, a small gap between the red baton and the open palm

Reading a Network Trace of a SQL Server Connection

March 20, 2010
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Security

Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.

Read More
Gouache painting: two long wooden boards lie parallel

JSON_ARRAY: Choose Whether NULL Elements Are Included

March 19, 2010
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL Server 2022

JSON_ARRAY constructs typed array text. Choose whether missing inputs disappear or remain JSON null placeholders before relying on positions.

Read More
SQL Server system log window.

SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

March 18, 2010
Pinal Dave
SQL Tips and Tricks
Microsoft Certifications, SQL Error Messages, SQL Mirroring, SQL Scripts

My friend kept getting the server network address cannot be reached error while testing mirroring configured without domain on his laptop. Here is why.

Read More
SQL SERVER - Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

March 17, 2010
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Index, SQL Scripts, SQL Server

We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.

Read More
Gouache painting: on a sports room wall, three identical brass whistles hang in a row from wooden pegs

XML value: Select One Typed Scalar

March 16, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.

Read More
Execution plan comparison.

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

March 15, 2010
Pinal Dave
SQL Performance
SQL Scripts

The MAXDOP query hint limits how many CPUs a query can use, though not which ones. With OPTION (MAXDOP 1), the parallelism operator leaves the plan.

Read More
A barge unloading grain sacks at a quay, with a weighing scale and sorting table set before the storehouse.

Loading Large Files Fast With BULK INSERT

March 14, 2010
Pinal Dave
SQL Tips and Tricks
CSV, File format, SQL Log, SQL Server

BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.

Read More
Wide stone steps climbing a garden hillside toward a bench

A Learning Path for a New SQL Developer

March 13, 2010
Pinal Dave
SQL Tips and Tricks
Developer, SQL Joins, SQL Training, Starting SQL

A new SQL developer can build skill in a clear order: relational basics, T-SQL, data modeling, plans, testing, and safe deployment habits.

Read More
A hand pressing a signet ring into red sealing wax on a folded parcel, a candle and wax stick beside it

Connecting Java Applications With the JDBC Driver

March 13, 2010
Pinal Dave
SQL Tips and Tricks
Java, SQL Connection, SQL Server, SQL Server Encryption

Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.

Read More
Previous 1 … 462 463 464 465 466 467 468 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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