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
Query options in SQL Server.

SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results

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

A friend’s SSMS window returned only Command(s) completed successfully for every query. I logged in remotely and found what was wrong with that session.

Read More
Msg 297, Level 16, State 1, Line 1.

SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action

January 18, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts

Msg 297 appears when a user runs a DMV without the right permission. Ask your admin to GRANT VIEW SERVER STATE, and the DMV runs without errors.

Read More
SQL Server version info.

SQL SERVER – Get Server Version and Additional Info

January 17, 2010
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Utility

Most people check the SQL Server version with @@VERSION. I also like xp_msver, which shows extra details about the server where SQL Server is installed.

Read More
A SQL Server performance tool window.

SQL SERVER – Find Busiest Database

January 14, 2010
Pinal Dave
SQL Performance
SQL Scripts

How do you find the busiest database on a SQL Server instance? I use sys.dm_exec_query_stats to add up logical reads and writes for each database.

Read More
SQL Server fragmentation window.

SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation

January 12, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

What is fragmentation, and how do you detect fragmentation and eliminate it? I explain the internal and external types and what each one does to your pages.

Read More
SQL SERVER - The server network address "TCP://SQLServer:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

SQL SERVER – The server network address “TCP://SQLServer:5023” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

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

Error 1418 in database mirroring says the server network address cannot be reached. Try my suggestions one by one, starting with a NO RECOVERY restore.

Read More
SQL Server creation of index with ignore duplicate key.

SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior

January 6, 2010
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Transactions

When is IGNORE_DUP_KEY = ON useful? Jacob Sebastian and I built an example that shows its transactional behavior when you insert only nonduplicate rows.

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

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