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 ceramic bowls hold red beads joined by cream cords, with a blue bead resting in front.

geography Point: Latitude Comes Before Longitude

October 4, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geography Point uses latitude, longitude and SRID arguments. Its coordinate order differs from POINT text, so inspect both returned properties.

Read More
Detailed painting of a wooden drawer assembly with a fitted stop across its front opening and a loose red-ended peg on the workbench.

ALLOW_PAGE_LOCKS OFF Stops REORGANIZE

September 30, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server

ALLOW_PAGE_LOCKS OFF prevents a rowstore index from being reorganized. A controlled example shows the maintenance error, checks the index setting and verifies that enabling page locks allows REORGANIZE without changing the stored rows.

Read More
Index on View with Query Usage.

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

September 24, 2009
Pinal Dave
SQL Puzzle
SQL Index, SQL Scripts, SQL White Papers

A query on the base table used an index it did not own. It was the index on index view of the same table, an interesting observation from an optimization project.

Read More
SQL SERVER - Insert Values of Stored Procedure in Table - Use Table Valued Function

SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function

September 23, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Table Operation

How do you insert values of stored procedure output into a table? The traditional temp table way, and an alternate method with a Table Valued Function.

Read More
Gouache painting: on a farm table two bundles of asparagus, each tied with twine around three spears, sit side by side

Integer Division: Keep Quotient and Remainder Together

September 22, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

Integer division and modulo can reconstruct the original signed dividend. These read-only cases keep both operands, quotient, remainder and reconstructed value together.

Read More
SQL SERVER - Introduction to Service Broker and Sample Script

SQL SERVER – Introduction to Service Broker and Sample Script

September 21, 2009
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Download, SQL Scripts

Here is my introduction to Service Broker and sample script: messaging and queuing between instances, conversations and dialogs in SQL Server 2005.

Read More
SQL SERVER - Plan Caching and Schema Change - An Interesting Observation

SQL SERVER – Plan Caching and Schema Change – An Interesting Observation

September 14, 2009
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Documentation, SQL Profiler, SQL Scripts, SQL Server Management Studio, SQL Stored Procedure, SQL Utility, SQL White Papers

What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.

Read More
Previous 1 … 274 275 276 277 278 279 280 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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