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 shallow wooden trays on pale surfaces, connected by a blue cord, with a terracotta cord passing through the right tray.

geometry STIsValid: Parsed Shapes Still Need a Validity Check

June 22, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STIsValid checks whether a spatial instance satisfies the validity rules for its geometry type. I use two parsed lines to separate those questions. Successful construction alone does not establish that a shape is valid.

Read More
Critical error.

SQL SERVER – TRANSACTION, DML and Schema Locks

June 21, 2010
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Stored Procedure, SQL Transactions

Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.

Read More
Three small wooden sample pieces beside an open blank notebook and a plain magnifying glass.

How to Learn a New SQL Server Release Quickly

June 20, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.

Read More
Table showing clustered index entries.

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache

June 17, 2010
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts

What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.

Read More
Last date of a date table.

SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE

June 12, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

I repeat my DATETIME and DATETIME2 test with GETDATE instead of SYSDATETIME. See how the distinct values in each column compare this time.

Read More
Results window of join fails join.

SQL SERVER – Difference Between DATETIME and DATETIME2

June 11, 2010
Pinal Dave
SQL Performance
SQL DateTime, SQL Scripts

A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.

Read More
SQL SERVER - Difference Between GETDATE and SYSDATETIME

SQL SERVER – Difference Between GETDATE and SYSDATETIME

June 10, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

What is the difference between GETDATE and SYSDATETIME? GETDATE stops at milliseconds, while SYSDATETIME in SQL Server 2008 goes much finer.

Read More
Previous 1 … 255 256 257 258 259 260 261 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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