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 - Using "High Performance" Power Plan for SQL Server

SQL SERVER – Using “High Performance” Power Plan for SQL Server

April 27, 2015
Pinal Dave
SQL Performance
SQL CPU, SQL Server

A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.

Read More
Two apple collections show keeping every apple compared with selecting distinct ones

Interview Question of the Week #017 – Performance Comparison of Union vs Union All

April 26, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Union clause

Compare UNION vs UNION ALL with duplicate examples, compatible types, actual plans, and the extra work required for distinct rows.

Read More
SQL SERVER - Generate Different Random Number for Each Group Using RAND() Function

SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function

April 25, 2015
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Random

The RAND() function returns the same value for every row in a query. Here is a simple trick to generate a different random number for each group.

Read More
SQL SERVER - Different Methods to Know Parameters of Stored Procedure

SQL SERVER – Different Methods to Know Parameters of Stored Procedure

April 24, 2015
Pinal Dave
SQL Tips and Tricks
SQL Stored Procedure

Need to know parameters of stored procedure code quickly? Here are two methods, including sp_help, that list each parameter with its type and order.

Read More
SQL Server - Error While Enabling CDC on a Table - The specified '@server' is invalid (valid values are returned by sp_helpserver)

SQL Server – Error While Enabling CDC on a Table – The specified ‘@server’ is invalid (valid values are returned by sp_helpserver)

April 24, 2015
Pinal Dave
SQL Tips and Tricks
Change Data Capture

A reader got an error while enabling CDC on a table: The specified ‘@server’ is invalid. Here is what the message means and what caused it for him.

Read More
A cheerful man with a beard.

Hey DBA – Watch Your Vendors! Hey Vendors – Try a Little Harder! – Notes from the Field #077

April 23, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server

Notes from the Field #077: Mike Walsh asks every DBA to watch their vendors, and asks vendors to try a little harder. Lessons for both sides.

Read More
Gouache painting of two storehouses on a canal joined by a plank bridge with a red handcart crossing

How to Identify Cross-Database Transactions in SQL Server

April 22, 2015
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Transactions

To find cross-database transactions, search the code for references to other databases, watch a live transaction with a DMV, or read special records in the transaction log. This post tests all three on two demo databases. It also shows why a popular log script flags a brand new database.

Read More
Sql sever split comma separated list.

SQL SERVER – Split Comma Separated List Without Using a Function

April 21, 2015
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

I have shown how to build a comma separated list many times. This time a reader wanted the reverse: split a comma separated list into rows without a function.

Read More
Gouache painting: a tray of freshly glazed clay cups waiting on a drying rack beside a kiln, one cup with a vermilion glaze, the rest unglazed

Dirty Pages in Memory: Count Them Before and After CHECKPOINT

April 20, 2015
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Memory, SQL Scripts, SQL Server Architecture

Dirty pages in memory are changed data pages that SQL Server has not yet written to disk. This post counts them with sys.dm_os_buffer_descriptors on SQL Server 2025, before and after CHECKPOINT, and explains why the same script can show nothing on newer servers.

Read More
A closed gate blocks access to a bridge that remains in place

Interview Question of the Week #016 – How to Take Database Offline

April 19, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Take a database offline with the right waiting policy, compare detach and SINGLE_USER, and verify SQL Server state before and after.

Read More
Previous 1 … 265 266 267 268 269 270 271 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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