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
Gouache painting: two wooden ladders leaning on one orchard wall, a short one beside a tall one with identical lower rungs, one vermilion rung on the short ladder

Redundant Indexes: Index on Col1, Col2 vs Col1, Col2, Col3

January 4, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Index, SQL Scripts

Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.

Read More
A guest book lying open on a hallway table with a pen across the page, the entries too soft to read.

SQLAuthority News – Year 2012 in Review – Perspective of Blog

January 3, 2013
Pinal Dave
SQLAuthority News
SQL Milestone

The Year 2012 for this blog in numbers: about 19 million views, 372 new posts and 2,360 in total. Thank you for making SQLAuthority.com a place to learn.

Read More
Gouache painting of one long cream paper ribbon folding back and forth in neat even rows to fit inside a slate blue frame, with a vermilion bookmark at the first fold.

Wrap SQL Code in SSMS: SQL in Sixty Seconds #038

January 2, 2013
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Configuration, SQL Server Management Studio, SQL Shortcut

You can wrap SQL code in SSMS so long lines fit the window and you never scroll sideways. This post gives the exact menu path, what each option on that page does, a long query to test it with and a shortcut for switching it on and off.

Read More
A brass plumb bob on a string beside a leaning brick wall, with a trowel and mortar bucket waiting on the grass

Performance Baseline in SQL Server: Measure Before You Tune

January 1, 2013
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, SQL Performance, SQL Server

Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.

Read More
SQLAuthority News - Last Post of Year 2012

SQLAuthority News – Last Post of Year 2012

December 31, 2012
Pinal Dave
SQLAuthority News

My last post of year 2012 remembers 37 SQL in Sixty Seconds episodes, nine Memory Lane articles, community events and family moments.

Read More
SQL SERVER - Fix: Error: The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". (SQL Server Import and Export Wizard)

SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)

December 30, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Importing Excel data with the Import and Export Wizard failed with a potential loss of data error. Here is what causes it and how to fix it.

Read More
A glass-fronted emergency box with a spare key inside and a small red hammer on a chain.

Regaining sysadmin Access When Nobody Can Log In

December 29, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Server, SQL Server Security

Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.

Read More
A wheel of cheese cut into wrapped wedges on a wooden board, a long knife across it, one wedge bigger.

Sharding: When One Server Is Not Enough

December 28, 2012
Pinal Dave
SQL Tips and Tricks
Database, Software Development, SQL Server, Table Partitioning

Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.

Read More
SQL SERVER - Creating Database with Different Collation on Server

SQL SERVER – Creating Database with Different Collation on Server

December 27, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.

Read More
Gouache painting of a finished blue vase beside an identical twin packed safely in a crate with red cloth

Take a Database Backup in SSMS: Step by Step

December 26, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Management Studio

To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.

Read More
Previous 1 … 354 355 356 357 358 359 360 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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