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 of a frayed woven strip held between wooden guides beside red scissors and trimmed fibers.

TRIM Function in SQL Server: SQL in Sixty Seconds #040

January 23, 2013
Pinal Dave
SQL Video
SQL Function, SQL in Sixty Seconds, SQL Server 2017, SQL Server 2022, SQL String

The TRIM function removes spaces from the ends of a string, and SQL Server has had it since 2017. The tests here show which characters TRIM leaves behind, the LEADING and TRAILING keywords, and a WHERE clause that read 884 pages against 3.

Read More
Gouache painting: a room that overflowed, extra folding chairs lined along every wall, one chair vermilion

SharePoint Conference Singapore 2013: A Great Experience

January 22, 2013
Pinal Dave
SQLAuthority News
Conferences, SharePoint, SQLAuthority Author Visit

I had the great pleasure of presenting at SharePoint Conference Singapore 2013, my second visit to the event. I shared three database tips in a session inspired by SQL in Sixty Seconds, and the room overflowed. Here is my recap, with photographs.

Read More
Three mushroom drying strings holding many recent and fewer selected older slices

Grandfather-Father-Son Retention: Choosing Which Backups to Keep

January 21, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.

Read More
A stone sundial in a walled garden at midday with a crisp shadow, a trowel and a basket of cut flowers on its plinth.

Designing a Date Dimension

January 20, 2013
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL DateTime, SQL Server

A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.

Read More
An ice cube tray with some cells full, some half full and some empty, a red cube beside it

Why Table Size Numbers Disagree: Reserved, Used and Unused Space

January 19, 2013
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL DMV, SQL Server, SQL Server DBCC

Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.

Read More
SQL SERVER - A List of Various SQL Server RTM and Service Pack Number

SQL SERVER – A List of Various SQL Server RTM and Service Pack Number

January 18, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server, SQL Service Pack

Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.

Read More
SQL SERVER - An Interesting Case of Redundant Indexes - Index on Col1, Col2 and Index on Col1, Col2, Col3 - Part 4

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

January 17, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts

A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.

Read More
Gouache painting of a sealed envelope travelling along a wooden rail into an open blue mailbox.

Configure Database Mail in SQL Server: SQL in Sixty Seconds #039

January 16, 2013
Pinal Dave
SQL Video
Database Mail, SQL in Sixty Seconds, SQL Server Agent, SQL Server Configuration

To configure Database Mail, you need an SMTP account, a profile and permission to use it. The tests here build all three with T-SQL on SQL Server 2025, show the exact errors for missing access, and follow a failed send through the mail log.

Read More
SQL SERVER - Introduction of Showplan Warning

SQL SERVER – Introduction of Showplan Warning

January 15, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

SQL Server can be your performance tuning teacher. Vinod Kumar explains the Showplan Warning in execution plans and what each warning is telling you.

Read More
Gouache painting: a wooden crate riding on a long luggage trolley through three open stone archways in a row, a small vermilion luggage tag tied to the crate's rope handle

CONTEXT_INFO: Passing a Value Through a Session

January 14, 2013
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Scripts, SQL Trigger

CONTEXT_INFO lets you attach a small value to a session and read it anywhere in that session, even inside a trigger. This post tests SET CONTEXT_INFO on SQL Server 2025, uses it to log who changed a price, and compares it with SESSION_CONTEXT.

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

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