Technical Article

Number of words within a phrase function

Most word count functions/procedures are based on some form of looping methods. If the table is large or there is a need to count the words in a number of columns, this can become quite an exercise. This function, based on a mathematical model, will work much faster and more efficient in counting the words […]

You rated this post out of 5. Change rating

2005-12-28 (first published: )

269 reads

Technical Article

Table Pivoting revisited

A lot of table pivoting scripts use cursors to reach the  desired results, but SQL scripting was developed to be utilized in a data set environment rather than sequential step-thru scripting.Normally, there are 3 types of Table Pivoting - 1) column explicit 2) column implicit and 3)single column.  COLUMN EXPLICIT will place the row value […]

You rated this post out of 5. Change rating

2003-05-29

412 reads

Technical Article

Phone Number Normalization even with literals

The script will do the following:- build a ten digit phone number regardless of input column size.- Ignores extensions- Ignores leading 1, as in 1(800)...- Ignores most special characters or spaces- converts literals to digitsIt can be easily convert to a UDFEnjoy.C. Z. Ovits

You rated this post out of 5. Change rating

2002-10-28

559 reads

Technical Article

Table structure in 8 x 11 w/size, rows & indexes

Using the sp_help to get a table structure is very cumbersome.  First, in order to print it you have to use"Results in Text" not "Results in Grid".  Second, the results are very wide screen-wise and very hard to read or print.  Third, you do not get the size or number rows with the same request.This […]

5 (1)

You rated this post out of 5. Change rating

2002-10-28

183 reads

Blogs

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

By

UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...

Read the latest Blogs

Forums

Botched "Data warehouse" design...

By pietlinden

Someone landed a PowerBI mess in my lap, and near as I can tell,...

disaster recovery

By sqlfriend

We have two data centers in same city. One is our main site, the...

Set up Availability Group without a cluster to create read-only database

By koln

I want to have a a secondary ready-only database available for reporting, which is...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers