t-sql function to parse string data

The below function can be used to parse or split out data from a delimited string. The function takes in 3 parameters. The text you want to parse, the 1 character delimiter, and the total count of objects in the text.Text for function is set at size of varchar(2000), feel free to make bigger if […]

2005-01-19 (first published: )

1,792 reads

Script to gain capacity information

Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers.  although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time.  […]

5 (2)

2002-09-20

263 reads

Blogs

Quick Start to Using Influxdb on Macos

By

Intro OSS 2.0 is a release candidate at this time, so this may change once...

Error: 8623 - The query processor ran out of internal resources and could not produce a query plan

By

 Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...

Goal Progress– October 2020

By

This is my report, which continues on from the Aug report. After that report,...

Read the latest Blogs

Forums

How to minimize the SQL Server log growth

By 892717952

In SQL Server 2014,  I go to my database properties and tempdb's database properties...

What is Possible?

By Kathi Kellenberger

Comments posted to this topic are about the item What is Possible?

I cannot add a replica because of difference between instances

By vavoem

Hi There, Let me start with to say I am not a SQL administrator,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers