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
Error dialog with error code 42000.

SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)

June 5, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

An AlwaysOn resource would not come online, and the cluster log showed sp_server_diagnostics failing with error 297, no permission. Here is the fix.

Read More
Three wooden gauge blocks fall below, meet, and rise above a measuring thread

How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125

June 4, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Datatype, SQL Function, SQL Scripts, SQL Server

How do you round up or round down a number in SQL Server? A quick answer using ROUND, CEILING and FLOOR, and how each one behaves.

Read More
Two complementary ceramic components fit together into one complete tile.

SQL SERVER – Alternate to AGENT_DATETIME Function

June 2, 2017
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

This Alternate to AGENT_DATETIME converts integer date and time values without calling an msdb function. I preserve leading zeros in the time.

Read More
SQL SERVER - Master Database in Single User Mode - A Serious Issue

SQL SERVER – Master Database in Single User Mode – A Serious Issue

June 1, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, System Database

A client found the master database in single user mode, yet everything worked and switching back to MULTI_USER failed with Msg 5058. Here is the story.

Read More
Loose threads feed a loom and become a new piece of cloth

How to Insert Results of Stored Procedure into a Temporary Table? – Interview Question of the Week #124

May 28, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure, Temp Table

How to insert results of stored procedure into a temporary table without creating the table first? Here is a simple script that shows the steps.

Read More
Adding Column to SQL Server Table.

SQL SERVER – Observation – Adding a NULL Column and Table Space

May 26, 2017
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL DMV, SQL Scripts, SQL Server

Does adding a NULL Column with no default make a table bigger? Usually not. A reader’s question and a practical example that measures it.

Read More
SQL Server DB Size.

SQL SERVER – Simple Query to List Size of the Table with Row Counts

May 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL System Table

A simple query I run at customer sites to list every table with its size in MB and Row Counts, including used and unused space.

Read More
Previous 1 … 126 127 128 129 130 131 132 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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