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
Execution Plan Tool Window.

SQL SERVER – Interesting Observation – Use of Index and Execution Plan

November 30, 2008
Pinal Dave
SQL Performance
Best Practices, SQL Index, SQL Scripts

Three AdventureWorks examples show how the Query Optimizer picks an index, what happens when you force one, and how that changes the index and execution plan.

Read More
Four unequal woven cloth strips form one continuous sequence across an oak bench in a sunlit stone workshop.

Running Start Times: Build an Agenda With SQL

November 25, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Order By, SQL Scripts

Running start times depend on the durations that precede each activity. Use ordered window sums while retaining full dates and explicit end boundaries.

Read More
SQL Server results window with contact information.

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008
Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Scripts

Two simple AdventureWorks queries return the same rows in a different order without ORDER BY. I explain why that order is never guaranteed.

Read More
SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database Including Schema

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema

November 22, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Stored Procedure

An improved script to print all stored procedures of database, now with schema names. Jerry Hung’s cursor uses sys.all_objects and sp_HelpText.

Read More
SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

November 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts, SQL Stored Procedure

A simple cursor with sp_HelpText can print all stored procedures of your database. Switch results to text view with CTRL+T to read them easily.

Read More
A row of plain glass jars holds different levels of sand on a sunlit shelf.

Baselines: Knowing What Normal Looks Like

November 12, 2008
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.

Read More
SQL SERVER - Delete Backup History - Cleanup Backup History

SQL SERVER – Delete Backup History – Cleanup Backup History

November 11, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Scripts, SQL Stored Procedure

SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.

Read More
Previous 1 … 295 296 297 298 299 300 301 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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