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
A spokeshave follows a straight spindle, leaving neatly aligned wood shavings

POC Index: Supporting Window Functions Without a Sort

October 18, 2011
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server

Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.

Read More
SQL SERVER - Three DMVs - sys.dm_server_memory_dumps - sys.dm_server_services - sys.dm_server_registry

SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

October 16, 2011
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server

Three new DMVs in SQL Server Denali: sys.dm_server_memory_dumps, sys.dm_server_services and sys.dm_server_registry. What they return, and a question for you.

Read More
A closed egg coddler with a lifting ring beside an opened matching vessel

Certificate-Signed Procedures That Read Server DMVs Safely

October 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.

Read More
A violin mute, bridge, and string fragments preserved together on soft cloth

Checking for SQL Server Dump Files After a Crash

October 12, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Did the server really crash, or just restart? Here is how to list dump files, read the error log and protect the evidence before anyone cleans up.

Read More
A firmly planted bicycle kickstand supports a bicycle on level stone

Blocking DELETE Without a WHERE Clause Using a Trigger

October 8, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.

Read More
A long sock on a wooden stretcher, with its small toe section drawn forward

A Page of Rows and the Grand Total Count in One Query

October 7, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

One query can give a grid its ten rows and the total for the label. Here is how, plus the empty page trap that catches almost everyone.

Read More
SQL SERVER - Detecting Database Case Sensitive Property using fn_helpcollations()

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

October 6, 2011
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL DMV, SQL Function, SQL Scripts, SQL Server

Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.

Read More
Previous 1 … 216 217 218 219 220 221 222 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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