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
SQL Server query window displaying cost calculations.

SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2

December 23, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL View

A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.

Read More
Gouache painting: a battered tin box with its lid propped open stands on a bench

geometry Collections: Read Members With STGeometryN

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

geometry Collections hold member shapes that STGeometryN can return individually. I extract a point and a line from one fixed collection. A third request deliberately exceeds its member count.

Read More
SQL Server query window displaying cost calculations.

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

December 21, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL View

When is an index created on view actually used? After showing it is often ignored, I demonstrate a condition where SQL Server uses it, including NOEXPAND.

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

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

December 18, 2010
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server, SQL Training, SQL View

At my Hyderabad seminar someone asked: will an Index Created on a view be used when you query the view? Not always. Limitation 12 of views explained.

Read More
SQL Server query window with results for AdventureWorks2008R2.

SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative

December 15, 2010
Pinal Dave
SQL Performance
SQL Scripts

Server side paging in SQL Server 2012 is simpler with OFFSET and FETCH NEXT. I compare it with the older ROW_NUMBER and OVER method from SQL Server 2005/2008.

Read More
SQL SERVER - What is Page Life Expectancy (PLE) Counter

SQL SERVER – What is Page Life Expectancy (PLE) Counter

December 13, 2010
Pinal Dave
SQL Performance
SQL Scripts

What is Page Life Expectancy (PLE)? A quick query to read it from sys.dm_os_performance_counters, the recommended minimum of 300 seconds, and what it means.

Read More
SQL SEVER - Finding Memory Pressure - External and Internal

SQL SERVER – Finding Memory Pressure – External and Internal

December 10, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server

A quick query to find external and internal memory pressure in SQL Server and see how much memory each memory type is using right now.

Read More
Previous 1 … 240 241 242 243 244 245 246 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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