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: beside the bag on a wooden board lies a second pretzel that is almost whole, missing only a small torn piece from one arm

DATEADD Fractional Numbers: Truncate Before Addition

December 13, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

DATEADD fractional numbers are truncated, not rounded. Compare positive and negative day additions while preserving an explicitly typed date input.

Read More
SQL SERVER - ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

December 11, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts

Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.

Read More
Gouache painting: on a bright gym floor, one central blue mat has four neighbors

geometry STTouches: A Shared Boundary Is Not Interior Overlap

December 10, 2009
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STTouches tests whether shapes meet without their interiors intersecting. I keep that predicate separate from a general intersection check. Sharing an edge and sharing an area are different spatial relationships.

Read More
Gouache painting: two identical lengths of linen tape lie side by side on a loom bench, each standing for one day

CAST to date: Remove Time Without Moving the Day

December 8, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

CAST to date keeps the calendar day from a typed datetime2 value. The example preserves the original time and contrasts actual removal with a display that merely hides it.

Read More
SQLAuthority News - Notes from TechDays 2009 at Infosys, Bangalore

SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore

December 5, 2009
Pinal Dave
SQLAuthority News
MVP, SQL Scripts, SQLAuthority Author Visit

My notes from TechDays 2009 at Infosys, Bangalore on Nov 16-17: the largest Microsoft tech event at Infosys, with about 2,500 attendees in person and online.

Read More
Gouache painting of a document passing through a schema-shaped stencil

Validate an XML Document in T-SQL With an XSD Schema by Jacob Sebastian

December 2, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL XML

To validate an XML document in SQL Server, store an XSD in a schema collection and type the variable or column with it. Jacob Sebastian’s lesson is kept, and I added tests on SQL Server 2025 that show the error number for each kind of bad document and what DOCUMENT and CONTENT accept.

Read More
A seismograph drum with a calm ink line and one sharp spike, a fingertip pausing beside the spike

Reading the Error Log With T-SQL

December 1, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Error Messages, SQL Log, SQL Scripts

Reading the error log with T-SQL helps you search current and archived SQL Server messages, then set a useful log cycle schedule.

Read More
Previous 1 … 269 270 271 272 273 274 275 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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