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
Detailed painting of a boatyard inspection board with one filled square recess, one empty recess, and a matching loose block on the workbench.

Columns With No Statistics: Read Each Warning

July 10, 2009
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server, SQL Statistics

A columns-with-no-statistics warning needs a column-by-column investigation. Compare warning lists before and after targeted statistics creation, and check the actual query behavior before deciding that a missing statistic caused poor performance.

Read More
Blue wooden pins beside a long empty terracotta tray.

CAST Without a Length: The Default Can Truncate Text

July 4, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

CAST Without a Length can silently choose a target width that is too short for the source text. I compare omitted and explicit lengths. The same conversion syntax can look harmless while losing the end of a string.

Read More
Six empty ceramic cups in two rows, with terracotta, blue and pale glazes.

CROSS APPLY VALUES: Unpivot Fixed Columns and Preserve NULLs

July 3, 2009
Pinal Dave
SQL Tips and Tricks
PIVOT and UNPIVOT, SQL Joins, SQL Scripts, SQL Server

CROSS APPLY VALUES can turn a fixed set of columns into rows without dropping their NULL values. I make any missing-value filter explicit. That keeps the reshaping step separate from the decision to exclude data.

Read More
Results window for executing t-sql queries.

SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char

July 1, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility

What is the difference between Line Feed (\n) and Carriage Return (\r)? Why Windows, Mac and Unix read a new line differently, and what it means in T-SQL.

Read More
SQL SERVER - 2008 - Policy-Based Management - Create, Evaluate and Fix Policies

SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies

June 30, 2009
Pinal Dave
SQL Tips and Tricks
Policy Management, SQL Scripts, SQL Server Security

An introduction to Policy-Based Management in SQL Server 2008: facets, conditions, policies, and how to create, evaluate and fix non-complying policies.

Read More
SQL SERVER - SQL Server Management Studio New Features

SQL SERVER – SQL Server Management Studio New Features

June 28, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio

The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.

Read More
SQL SERVER - Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to 'master'.

SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.

June 27, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Trigger, sqlcmd

Dropped the database your logon trigger writes to? Every login then fails with Error 17892 Logon failed. I recreate the problem and show how to get back in.

Read More
Previous 1 … 279 280 281 282 283 284 285 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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