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 - Trace Flags - DBCC TRACEON

SQL SERVER – Trace Flags – DBCC TRACEON

May 30, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server DBCC

Trace flags let a DBA turn a database function on or off for a while. How to use DBCC TRACEON and TRACEOFF, with deadlock trace flag 1205 as the example.

Read More
SQL SERVER - Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table

SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table

May 30, 2007
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Identity, SQL Scripts

Msg 544, cannot insert explicit value for identity column, happens when IDENTITY_INSERT is OFF. Turn it ON, insert your rows, then turn it OFF again.

Read More
Gouache painting of a tall wooden library ladder leaning against slate blue shelves, eight rungs, the top rung painted vermilion

Change Database Compatibility Level in SQL Server Safely

May 29, 2007
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Performance, SQL Scripts

How to change database compatibility level in SQL Server 2025 with ALTER DATABASE. It covers the levels the server accepts, what the level changes in the optimizer, why single user mode isn’t needed, and a safe routine for raising the level with Query Store.

Read More
Matching brass fittings, blue wedges and wooden knobs align across two divided trays.

CTE Column Names: Rename Positions Without Moving Values

May 28, 2007
Pinal Dave
SQL Tips and Tricks
CTE, SQL Scripts, SQL Server

CTE column names rename positions without moving values. Compare inner aliases, report names and a misleading reversed list.

Read More
SQL SERVER - 2005 Limiting Result Sets by Using TABLESAMPLE - Examples

SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples

May 27, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Random, SQL Scripts

TABLESAMPLE returns a random sample of rows by percent or row count. My examples show why the same query returns a different number of rows each time.

Read More
SQL SERVER - 2005 Find Table without Clustered Index - Find Table with no Primary Key

SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key

May 26, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

A query on sys.indexes to find every table without clustered index in a database, why heaps can slow you down, and how to pick a clustered key.

Read More
Fill Factor.

SQL SERVER – Change Default Fill Factor For Index

May 25, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server Configuration

The Default Fill Factor in SQL Server is 0. Change it with sp_configure to leave free space on index pages and reduce page splits. I like mine at 90.

Read More
Previous 1 … 345 346 347 348 349 350 351 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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