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
Dbo' table in database.

SQL SERVER – Finding Size of a Columnstore Index Using DMVs

June 10, 2012
Pinal Dave
SQL Tips and Tricks
ColumnStore Index, SQL Index

This script uses sys.indexes and sys.dm_db_partition_stats to list the size of a columnstore index on disk, along with its table name.

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
SQL SERVER - A Puzzle - Swap Value of Column Without Case Statement

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

June 8, 2012
Pinal Dave
SQL Puzzle

An interview puzzle: write one UPDATE that flips male to female and female to male. Can you swap value of column data without a CASE statement?

Read More
A croquet mallet rests beside identical balls on the same flat strip of lawn

A Repeatable Workload: Testing a Tuning Change Fairly

June 7, 2012
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Monitoring, SQL Performance, Testing

One quick run can fool you. Here is a small, fixed test you can rerun before and after any index.

Read More
Gouache painting of a small red-tabbed group of cards separated from a larger file drawer by a brass guide.

Replace SELECT * with Column Names in SQL Server: SQL in Sixty Seconds #017

June 6, 2012
Pinal Dave
SQL Video
SQL Coding Standards, SQL Column, SQL in Sixty Seconds, SQL Server Management Studio, SQL View

Replace SELECT * with the columns your application needs. The tests here show a query that read 4 pages instead of 64, a view that missed a new column, and two errors that appear when a table changes, all on SQL Server 2025.

Read More
SQL SERVER - Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier

SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier

June 5, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Error 10920 stops you from dropping a user-defined function that is still the Resource Governor classifier. Here is why, and how to clean it up.

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
Sequence values displayed in SQL Server Management Studio.

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

June 2, 2012
Pinal Dave
SQL Puzzle

Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?

Read More
Gouache painting of an empty wooden stool at a workbench at dawn, with a folded letter sealed in vermilion wax resting beside a well worn tool left for a newcomer

A Letter to the Developer Starting Out

June 1, 2012
Pinal Dave
Personal
Best Practices, Career Advice, SQL Training

A letter to every developer starting out: it’s fine not to know, your hands learn slower than your head, choose people over perks, keep your promises and keep learning. One day you will be the one standing beside the bench.

Read More
Previous 1 … 375 376 377 378 379 380 381 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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