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
UNION result with all rows.

SQL SERVER – Introduction and Example of UNION and UNION ALL

October 15, 2008
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts, SQL Union clause

A simple example of UNION and UNION ALL with two table variables. UNION removes the duplicate rows, while UNION ALL keeps every row from both tables.

Read More
SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only

SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only

October 14, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

A simple UDF that gets only the numbers from an alpha numeric string, using PATINDEX and STUFF, with test values for empty, NULL and mixed strings.

Read More
SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds

SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds

October 10, 2008
Pinal Dave
SQL Performance
SQL Function, SQL Scripts, SQL String, SQL Utility

Need to remove trailing spaces, leading spaces, tabs, carriage returns and line feeds? Here is an enhanced TRIM function built from a script by Russ and Erik.

Read More
SQL Server 2005 Query Window.

SQL SERVER – 2008 – TRIM() Function – User Defined Function

October 9, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

SQL Server 2000, 2005 and 2008 have no TRIM() function, but LTRIM and RTRIM together do the job. Here is a simple UDF that trims both sides at once.

Read More
Gouache painting: five round buns sit in a row on a long bakery board

SUBSTRING Boundaries: Start at Zero, One or Beyond

October 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

SUBSTRING boundaries distinguish start zero, start one and positions past the end. Read empty strings, shortened counts and typed NULL results.

Read More
A rounded terracotta pot in a long shallow blue-gray ceramic tray.

STR: Check Width and Reduced Decimal Places

October 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

STR can reduce decimal places when its requested width cannot hold the complete fractional display. I inspect the complete text, including spaces and signs. A populated result does not guarantee that the number remains visible.

Read More
SQL Server execution plan.

SQL SERVER – 2008 – Find If Index is Being Used in Database

October 3, 2008
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts

How do you find if an index is being used in your database? My quick script checks sys.dm_db_index_usage_stats, so you can drop unused indexes safely.

Read More
Previous 1 … 298 299 300 301 302 303 304 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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