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
fun quotes

SQLAuthority News – Fun Quotes about Technology

March 31, 2010
Pinal Dave
Personal
SQL Humor, SQL Server

SQL Server can be a boring subject at times, so here are some fun quotes about technology from Thomas Edison, Douglas Adams and others to lighten the day.

Read More
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
Rich still life of an oak cabinet with divided open drawers, ivory spheres, folded linen and sage bowls.

Composite Index Without the Leading Key: Seek, Scan and Residual Filters

March 28, 2010
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server

A composite index orders rows by its leading key before the next key. Compare a date-only filter, region restrictions and an isolated date-first index. Verify complete results, including new regions and NULL, before interpreting actual plans.

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
Index Physical Statistics SSMS.

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

March 26, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Server Management Studio, SQL Utility

SSMS has a standard report for Index Physical Statistics at the database level. Right click the database, open Reports, and see index details at a glance.

Read More
SQL SERVER - Out of the Box - Activity and Performance Reports from SSSMS

SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS

March 25, 2010
Pinal Dave
SQL Performance
SQL Reports, SQL Server, SQL Server Management Studio

SSMS 2008 has built-in activity and Performance Reports most people never open. Right click the server, go to Reports, Standard Reports, and pick one.

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
Table with columns and rows.

SQL SERVER – Enumerations in Relational Database – Best Practice

March 22, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Documentation

Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.

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

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