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
Crates are held firmly inside a vehicle by cargo straps

How Much Memory is in Locked Pages? – Interview Question of the Week #228

June 9, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Memory, SQL Scripts, SQL Server

Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.

Read More
System boot time query result.

SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time

June 8, 2019
Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Scripts, SQL Server, Starting SQL

Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.

Read More
SQL SERVER - FIX: Msg 7416 - Access to the Remote Server is Denied Because No Login-mapping Exists

SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists

June 7, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.

Read More
Gouache painting of three seedling pots on a greenhouse bench, one quietly covered by a glass cloche with a vermilion rim

MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT: How to Check It Is On

June 6, 2019
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, Snapshot, SQL Memory, SQL Scripts, Transaction Isolation

MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT is a database option, so DBCC USEROPTIONS never shows it. This post reads the option from sys.databases and from DATABASEPROPERTYEX, turns it on in a demo database and finds every database that has it. It also shows a guarded script you can reuse in deployments.

Read More
coffee mug

Indexes and SELECT Queries: A Coffee Mug, Tested

June 5, 2019
Pinal Dave
Personal
SQL Index, SQL Performance, SQL Scripts

Indexes and SELECT queries met on a coffee mug from my friend Harvey Powell. Its two sides say indexes slow down SELECT queries and to drop unused indexes. The tests here show when a forced index reads 46 times more pages, what the usage counters report for an unused index, and why zero reads did not mean zero purpose.

Read More
Pumpkins in pairs on a farm stand, the smaller of each pair tied with a red ribbon, one unpaired pumpkin at the end.

Every Second Item Free: Pricing Promotions With ROW_NUMBER

May 27, 2019
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Scripts, SQL Server

Price every second item as free with ROW_NUMBER, expand quantities into units, and calculate basket discounts without double counting.

Read More
An empty park bench under falling blossoms shows why appearance alone cannot establish its last use

When was Table Accessed Last By User? – Interview Question of the Week #226

May 26, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Index, SQL Scripts, SQL Server, SQL Table Operation

When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.

Read More
Previous 1 … 72 73 74 75 76 77 78 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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