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 - Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server

SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server

January 24, 2014
Pinal Dave
SQL Tips and Tricks
Devart

The VALUES clause does much more since SQL Server 2008. Here is a Query Plan Analysis of PIVOT and UNPIVOT queries using the profiler in dbForge Studio.

Read More
Evaluate Policies Dialog Box.

SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012

January 23, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

Worried about your database while on vacation? John Sterrett shows how Policy Based Management helps a proactive DBA catch unwanted changes.

Read More
Two matching slate blue birdhouses on a fence post, one with a higher entry hole and no perch.

Comparing Two Database Schemas With T-SQL

January 22, 2014
Pinal Dave
SQL Tips and Tricks
Schema, SQL Scripts, SQL Server, SQL System Table

Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.

Read More
Old curtains hung in a new home's window after a move, ending a hand's width short of the sill.

Checking Data Type Mapping After a Database Migration

January 21, 2014
Pinal Dave
SQL Tips and Tricks
Compatibility Level, DBA, SQL Datatype, SQL DateTime, SQL Migration

Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.

Read More
Debugging tool window with three tabs.

SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip

January 20, 2014
Pinal Dave
SQL Interview Questions and Answers

Want to validate syntax without running a query? I explain the little known SET NOEXEC setting that checks your T-SQL but does not execute it.

Read More
SQL SERVER - Identify Oldest Active Transaction with DBCC OPENTRAN

SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN

January 19, 2014
Pinal Dave
SQL Tips and Tricks
SQL Transactions

How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.

Read More
A hand lowers one peg toward an accessible hole in a triangular solitaire board

Nested Loops Join: When It Is the Right Choice

January 18, 2014
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Index, SQL Joins

Loops in a plan are not always the villain. Count the inner executions and the reads before you force another join type.

Read More
SQL Server Authentication mode.

SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

January 17, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Login failed, the user is not associated with a trusted SQL Server connection, Error 18452? Usually it is a wrong username or Windows-only login mode.

Read More
Dbi_dboccLastKnownGood.

SQL SERVER – Check for Database Integrity – Notes from the Field #011

January 16, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

In this Notes from the Field episode, Tim explains why you should check database integrity often, so corruption is caught before it is too late.

Read More
A power strip under a table with cables to a lamp, a radio and a kettle, one cord vanishing through the floor.

Finding What Depends on a Table

January 15, 2014
Pinal Dave
SQL Tips and Tricks
SQL Dependency, SQL Server, SQL Stored Procedure, SQL System Table

Finding What depends on a table starts with sys.dm_sql_referencing_entities, then checks cross-database code and dynamic SQL.

Read More
Previous 1 … 314 315 316 317 318 319 320 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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