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
Two smooth stones on a round wooden board beside a loosely curved piece of plain string.

Storing and Querying Locations in SQL Server

March 30, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Work with spatial data in SQL Server using geography, geometry, matching SRIDs, distance queries, and an index designed for location searches.

Read More
SQL SERVER - Introduction to Extended Events - Finding Long Running Queries

SQL SERVER – Introduction to Extended Events – Finding Long Running Queries

March 29, 2010
Pinal Dave
SQL Performance
SQL Extended Events, SQL Scripts, SQL Server, SQL Training

After reading Jonathan Kehayias on Extended Events, I added them to my performance tuning course. An introduction, with a way to find long running queries.

Read More
Gouache painting of a coiled iron chain on an old stone quay beside an empty mooring ring, its first link painted vermilion

Error 4214: BACKUP LOG Needs a Full Backup First

March 27, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, Transaction Log

Error 4214 stops a log backup because SQL Server has no full backup to build on. It shows up after a switch from Simple to Full recovery, or on a database that never had a full backup. Take one full backup, and the log backup works.

Read More
Distributed Transaction Coordinator.

SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase

March 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts

Error 8501 says MSDTC on server is unavailable, often while configuring replication. Start the Distributed Transaction Coordinator service to fix it.

Read More
Gouache painting: four hop poles stand in a row with uneven gaps, close, wider, close

datetime: Read Its Fractional-Second Rounding

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

datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.

Read More
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
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
Previous 1 … 261 262 263 264 265 266 267 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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