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 - UDF - User Defined Function to Extract Only Numbers From String

SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String

April 11, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

A simple UDF, ExtractInteger, to extract only numbers from string input. I test it with a phone number that also has letters in it.

Read More
SQL SERVER - 2005 - Explanation of TRY...CATCH and ERROR Handling

SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling

April 11, 2007
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts, SQL Server Security

SQL Server 2005 brings TRY…CATCH for error handling, so you no longer check @@ERROR after every statement. Here is how the TRY and CATCH blocks work.

Read More
SQL SERVER - 2005 - Silent Installation - Unattended Installation

SQL SERVER – 2005 – Silent Installation – Unattended Installation

April 10, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

Silent installation of SQL Server 2005 in two steps: an .ini file built from template.ini, then setup.exe with /qn or /qb. Plus tips to test it.

Read More
SQL SERVER - Search Text Field - CHARINDEX vs PATINDEX

SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX

April 8, 2007
Pinal Dave
SQL Performance
SQL Function, SQL Scripts, SQL Server, SQL Server Security, SQL Utility

CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.

Read More
SQL SERVER - T-SQL Paging Query Technique Comparison - SQL 2000 vs SQL 2005

SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005

April 3, 2007
Pinal Dave
SQL Performance
SQL Download, SQL Scripts, SQL Stored Procedure

I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.

Read More
An overflowing storage cart stands beside a cramped alcove, with a spacious sunlit destination visible through the doorway.

SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.

April 1, 2007
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL TempDB

When TempDB is Full, I investigate capacity and usage before moving its files. A move requires a planned restart.

Read More
Metal scissors beside cream and vermilion ribbon strips, with a sage box on slate cloth.

STUFF Boundaries: Insert Text and Handle NULL Results

March 31, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

STUFF boundaries govern insertion and deletion. See valid positions, zero length, NULL replacement and out-of-range starts.

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

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