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 - Explain Error:166 : does not allow specifying the database name as a prefix to the object name - Puzzle to Win SQL Server Interview Questions and Answers Book

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

December 14, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

Why does DROP PROCEDURE with the database name as a prefix give Error 166 when DROP TABLE works? Explain it and win my SQL Server Interview Questions and Answers book.

Read More
SQL SERVER - A Quick Look at Performance - A Quick Look at Configuration

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

December 13, 2011
Pinal Dave
SQL Performance
SQL Scripts

Before I answer a performance question, I need to know the environment. Here is how I take a quick look at configuration to get the full picture fast.

Read More
A ring compressor encloses one piston while another piston remains outside its boundary

Foreign Keys Across Databases: What to Use Instead

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

SQL Server will not create a foreign key to another database. Here is the real error, why a report is only detection, and a same-database option that enforces.

Read More
A nutmeg grater beside a sound nutmeg and a cracked empty shell

Error 3241 on Restore: Newer Version or Damaged Backup File

December 10, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Error 3241 only says SQL Server could not read the file as a backup. Here are three broken files, three different messages, and the checks to run first.

Read More
SQL SERVER - Bad Practice of Using Keywords as an Object Name - Avoid Using Keywords as an Object

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

December 9, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Why using keywords as an object name is a bad practice: a stored procedure named GO runs with EXEC GO, and the result can surprise you.

Read More
A scythe stone beside aligned blade and handle parts with their fitted joint visible

Statement Terminators: Where T-SQL Requires a Semicolon

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

Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.

Read More
A small wooden staircase model beside a plain closed toolbox in soft natural window light.

What a Junior DBA Should Learn First

December 6, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.

Read More
Previous 1 … 210 211 212 213 214 215 216 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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