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 carpet stretcher pulls ripples flat while the carpet remains uncut and keeps its existing edges

ALTER TABLE REBUILD: Fixing a Heap Without a Clustered Index

August 8, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Heap, SQL Index, SQL Table Operation

A heap with widening rows collects forwarded records. Here is how to measure them, fix them and know when the fix will not last.

Read More
A riveting tool aligns a new rivet with existing holes that preserve the old fastening positions

Explicit Identity Values: Loading Rows With Their Old Keys

August 7, 2012
Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Identity, SQL Migration, SQL Table Operation

Moving rows and keeping their old keys? Here is the safe order of steps, and the counter check that saves you from a collision.

Read More
A bicycle wheel leans on a wall with one bent spoke, while loose spokes and a spoke key lie on the floor

Comparing Session SET Options Between SSMS and the Application

August 6, 2012
Pinal Dave
SQL Performance
SQL Cache, SQL Connection, SQL DateTime, SQL Server Management Studio

Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.

Read More
A willow swaying in the wind above a pond, its reflection trailing slightly behind the real branches.

Offloading Reports to a Readable Secondary

August 5, 2012
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL High Availability, SQL Reports, SQL Server

Readable secondary replicas can serve reports away from a SQL Server primary; learn routing, lag, licensing, and query differences to test.

Read More
SQL SERVER - Fix: Error: 8117: Operand data type bit is invalid for sum operator

SQL SERVER – Fix: Error: 8117: Operand data type bit is invalid for sum operator

August 4, 2012
Pinal Dave
SQL Tips and Tricks

Error 8117 appears when you SUM a BIT column, because bit is invalid for sum operator. I reproduce it with a small table and show a simple workaround.

Read More
Work briefcase beside new notebooks and an apple on a classroom desk

SQLAuthority News – Learning Never Ends – Becoming Student Again

August 3, 2012
Pinal Dave
SQLAuthority News
SQL Training, SQLAuthority Author Visit

Learning should never stop. Visiting a friend’s new training center got me thinking about Becoming Student again, and why I keep learning even from old material.

Read More
SQL SERVER - Beginning of SQL Server Security

SQL SERVER – Beginning of SQL Server Security

August 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.

Read More
Five pitfalls with their results: FORCESCAN read 225 pages instead of 2, @@ERROR was 0 after a PRINT, a schema GRANT reached a later table and a DENY removed it, modify() failed with Msg 2337 and Msg 5302, and recursion stopped with Msg 530 at level 100

SQL Server Pitfalls: Five Short Lessons With the Fix for Each

August 1, 2012
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Error Messages, SQL Server Security, SQL XML

SQL Server pitfalls start with a small assumption. This page shows five of them, one for each topic: query hints, errors, permissions, XML and recursive queries. Each lesson shows the mistake first and the tested fix second. Every result comes from SQL Server 2025.

Read More
Three small wooden boxes connected by short lengths of plain cord on a warm tabletop.

What Distributed SQL Means and What It Costs

August 1, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand distributed SQL through data placement, compute and storage roles, write coordination, and the latency and operating costs behind scale.

Read More
A conveyor belt of identical parcels beside a single hand trolley carrying one parcel

What Is a Cursor in SQL Server, and When to Avoid One

July 31, 2012
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Scripts, SQL Server

A cursor in SQL Server took 260 milliseconds where one SELECT took 4. Why the gap exists, how to turn a loop back into a set, and the three cases where a cursor really is the right answer.

Read More
Previous 1 … 369 370 371 372 373 374 375 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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