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
Operation Delete and Delete Operation.

SQL SERVER – Index Levels and Delete Operations – Page Level Observation

September 7, 2010
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Scripts

When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.

Read More
SQL SERVER - Index Created on View not Used Often - Limitation of the View 3

SQL SERVER – Index Created on View not Used Often – Limitation of the View 3

September 6, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL View

An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.

Read More
Gouache painting: three young apple trees stand in a row in a grassy orchard

FOR JSON PATH: Choose Whether NULL Properties Appear

September 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output example.

Read More
A crate of blue ceramic bowls, a separate sample bowl and a clay inspection token.

Return Codes: Keep Procedure Status Separate From Data

August 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Stored Procedure

Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.

Read More
SQL SERVER - Plan Cache - Retrieve and Remove - A Simple Script

SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script

August 28, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server

A simple script to retrieve the plan cache for one query and remove just that plan, instead of clearing the whole cache on a busy server.

Read More
Execution Plan for Select Query Using View.

SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2

August 26, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL View

Need one more column from a view? Joining table outside view is expensive, and changing the view adds network traffic for every query. Views limitation part 2.

Read More
Two adjacent filter beds contain the same coarse and fine sections in reversed positions.

SQL SERVER – Does Order of Column in WHERE Clause Matter?

August 25, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

Does the Order of Column in WHERE Clause change a query plan? I invite a runnable example with a controlled comparison.

Read More
Previous 1 … 249 250 251 252 253 254 255 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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