Miscellaneous

Technical Article

Smart data archiving stored procedure

  • Script

This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table.  The procedure assumes that the production and archive tables will have the same structure.  The procedure uses the following input parameters:@SourceTable:  This is the name of the table […]

You rated this post out of 5. Change rating

2007-09-05 (first published: )

4,065 reads

Technical Article

Clean up default constraints

  • Script

The script scrapes out all default constraints (optional for particular column, table or script generation for the whole db) in SQL Server 2005 manner. Based on: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00a11.asp

You rated this post out of 5. Change rating

2007-09-03 (first published: )

580 reads

Technical Article

Function returns String in Proper Case [CamelCase]

  • Script

This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'

4.75 (8)

You rated this post out of 5. Change rating

2007-05-09 (first published: )

21,819 reads

Technical Article

Function to Split a Delimited String into a Table

  • Script

This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]

3.17 (6)

You rated this post out of 5. Change rating

2007-05-25 (first published: )

5,669 reads

SQLServerCentral Article

Keyword Searching in SQL Server

  • Article

Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.

4.6 (5)

You rated this post out of 5. Change rating

2008-02-21 (first published: )

12,037 reads

Blogs

Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab

By

Are you diversifying your DBA skillset? My recent job search made one thing clear:...

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Read the latest Blogs

Forums

RESTORE DATABASE command internal timeout

By MikeDBA

I have run into a very strange issue restoring a large, partitioned database. I...

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers