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
Errmsg about logins created with password.

SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin

June 21, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

Moving logins with sp_help_revlogin, I hit Msg 15419: supplied parameter sid should be binary(16). Here is what causes it and how to fix the script.

Read More
Loom stations have different amounts of waiting work in their baskets

How Much Work Each Processor (CPU) is Doing in SQL Server? – Interview Question of the Week #178

June 17, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL CPU, SQL DMV, SQL Scripts, SQL Server

A client with 56 processors saw CPU always high and wanted to know how busy each one was. Here is a simple DMV query that shows work per Processor (CPU).

Read More
Over and partion by query results.

SQL SERVER – Adding Values WITH OVER and PARTITION BY

June 16, 2018
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Order By, SQL Scripts, SQL Server

How do you sum values for each group without GROUP BY and still keep every row? Here is how SUM with OVER and PARTITION BY answers a reader’s question.

Read More
SQL SERVER - How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?

SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?

June 14, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio

A DBA asked for a shortcut to drop more than one table at once in SSMS without writing T-SQL. Here are the simple steps, using just the keyboard.

Read More
Illustrated cover: Implicit Conversion

SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?

June 11, 2018
Pinal Dave
SQL Performance
SQL Function, SQL Scripts, SQL Server

CONVERT_IMPLICIT warnings are one of the most common performance issues I find in health checks. Here is how to find them in your queries and how to fix them.

Read More
Several similar sparrows and one different bird gather at a feeder

How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177

June 10, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts, SQL Server

What is Cardinality, and how do you find it for a column? This simple script shows the percentage of unique values, using an AdventureWorks table.

Read More
Gouache painting of five glasses of water at different levels with the fullest one rimmed in vermilion

Find Memory Used by Each Database in SQL Server

June 9, 2018
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Memory, SQL Scripts, SQL Server

To see the memory used by each database, count its pages in the buffer pool with sys.dm_os_buffer_descriptors. This post builds a small demo database, shows buffer and dirty page sizes before and after a checkpoint, explains the row with no name, and covers what the buffer pool numbers leave out, such as the plan cache.

Read More
Previous 1 … 97 98 99 100 101 102 103 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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