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
A small wooden card organizer holding plain blank dividers beside a closed notebook on a desk.

Building a Reference You Will Actually Use Again

June 15, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.

Read More
SQL SERVER - Solution of Puzzle - Swap Value of Column Without Case Statement

SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement

June 14, 2012
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts

Readers sent more than 50 answers to my swap puzzle. Here are 5 different ones that swap a column value without CASE statement, plus my own three.

Read More
SQL SERVER - Service Broker and CAP_CPU_PERCENT - Limiting SQL Server Instances to CPU Usage

SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage

June 9, 2012
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts

Jeff said my Resource Governor script did not limit CPU at all. After a few emails we found why, and how CAP_CPU_PERCENT really limits CPU usage.

Read More
Diagram of the Resource Governor flow using the names from the example: requests go to the classification function dbo.UDFClassifier, which routes them to ReportServerGroup, PrimaryServerGroup or the default group, and each group uses its own resource pool; the report pool is limited to 30 percent of CPU and memory

Resource Governor Workload Groups and Pools: A Simple Setup Example

June 4, 2012
Pinal Dave
SQL Tips and Tricks
Resource Governor, SQL Performance, SQL Scripts, SQL Server

Resource Governor workload groups let you limit CPU and memory for competing workloads. This introduction answers what Resource Governor is and why you need it, then shows a full T-SQL setup example.

Read More
A parcel sorting table where one wrapped package has been set down in the wrong chute mouth.

SQL SERVER – Fix: Error 147 An aggregate may not appear in the WHERE clause

June 3, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Error 147: An aggregate may not appear in the WHERE clause. A beginner was stuck on it for a long time, so here is the simple fix, explained for beginners.

Read More
SQL SERVER - A Puzzle - Fun with SEQUENCE in SQL Server 2012 - Guess the Next Value

SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

May 25, 2012
Pinal Dave
SQL Puzzle
SQL Scripts

A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?

Read More
SQL SERVER - A Puzzle - Fun with NULL - Fix Error 8117

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117

May 24, 2012
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.

Read More
Previous 1 … 203 204 205 206 207 208 209 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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