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 brass door viewer set in a heavy panelled door, its little shutter closed from the inside.

SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database

January 5, 2010
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.

Read More
SQL error on unique index creation.

SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON

January 4, 2010
Pinal Dave
SQL Performance
SQL Error Messages, SQL Index, SQL Scripts

What does IGNORE_DUP_KEY = ON do on a unique nonclustered index? Duplicate inserts give a warning instead of an error, and my example shows both options.

Read More
SELECT SUBSTRING SQL command.

SQL SERVER – Find Location of Data File Using T-SQL

January 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts, SQL Server

A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.

Read More
SQL SERVER - FIX: Error: 1807 Could not obtain exclusive lock on database 'model'. Retry the operation later.

SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later.

January 1, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Error 1807 says SQL Server could not obtain an exclusive lock on database ‘model’ during CREATE DATABASE. The fix that worked for me takes seconds.

Read More
A weather vane on a barn roof caught mid-spin with motion blur, against a flat grey sky.

SQL SERVER – Fix Error 1949, Level 16: Cannot create index on view. The function yields nondeterministic results

December 30, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL View

Fix Error 1949: cannot create index on view because a function yields nondeterministic results. A training attendee hit it; removing that function solved it.

Read More
SQL SERVER - Get Date of All Weekdays or Weekends of the Year

SQL SERVER – Get Date of All Weekdays or Weekends of the Year

December 29, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Tejas Shah’s easy script to list the date of all weekdays or weekends of a year with a recursive CTE, first written to find every Sunday of 2010.

Read More
Temp Table and Table Variable execution differences.

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

December 28, 2009
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Transactions

Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.

Read More
Previous 1 … 267 268 269 270 271 272 273 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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