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 […]

2005-12-28 (first published: )

267 reads

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 […]

2003-05-29

412 reads

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)

2002-10-28

181 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

FOR JSON command adding carriage return to output

By fxferguson

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

Create a delta from downloaded info

By Bruin

I'm looking for some suggestions on how to create a delta file that will...

Last Time Stored Procedure Ran ?

By homebrew01

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful  as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers