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 - Check Database Integrity for All Databases of Server - DBCC CHECKDB

SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB

November 10, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server, SQL Server DBCC

A quick script to check database integrity for all the databases on a server with DBCC CHECKDB and sp_msforeachdb, and how to read its output.

Read More
Small wooden trays arranged in a compact sequence with beans sorted into separate groups.

Why WHERE Runs Before SELECT

November 9, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.

Read More
SQL SERVER - Refresh Database Using T-SQL

SQL SERVER – Refresh Database Using T-SQL

November 7, 2008
Pinal Dave
SQL Performance
SQL Scripts, SQL Server DBCC, SQL Stored Procedure

Can you refresh database in Object Explorer using a T-SQL query? No. But if cached objects changed, DBCC commands can clear the cache for you.

Read More
SQL Server 2005 connection window.

SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio

November 5, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, SQL Scripts, Vista

Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.

Read More
SQL Server master connection window.

SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user

November 4, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Error 4064, cannot open user default database, shows up when a login’s default database was dropped. Connect to master first, then change the default.

Read More
Execution plan table shows up.

SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan

November 1, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

Here is what I found about WITH ENCRYPTION and execution plan: an encrypted SP hides its actual execution plan too. Two sample SPs show it.

Read More
SQL SERVER - DECLARE Multiple Variables in One Statement

SQL SERVER – DECLARE Multiple Variables in One Statement

October 31, 2008
Pinal Dave
SQL Performance
Best Practices, SQL Scripts

Yes, you can DECLARE multiple variables in one statement in SQL Server. Compare both methods side by side: one statement per variable, or all in one line.

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

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