Miscellaneous

Technical Article

Script SQL Database DDL

  • Script

This tool scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"]. These files can then be placed under proper source management control. An entire database is scripted in one call.Alternatively, it provides a way to simply document the contents of […]

2.33 (3)

You rated this post out of 5. Change rating

2007-03-12 (first published: )

2,268 reads

Technical Article

Proper Case A String Or Name

  • Script

SQL 2005 user defined function to convert a string to proper case (title case).Flexible handling of delimiters and apostrophes to cater for words like "hasn't" and also names like "O'Reilly" and "d'Angelo".Mac and Mc surnames are handled generically, with some rules and exceptions which may need to be extended.  Since McIntyre and Mcintyre are both […]

5 (2)

You rated this post out of 5. Change rating

2007-03-14 (first published: )

1,836 reads

Technical Article

PARSENAME Enhancement

  • Script

The ParseName function is very useful for getting parts out of a string of characters between delimiters. But a limitiation is that you only can get four parts out, and the function only accepts dots as delimiters.The function I have written below overcomes that limitations, and add a new feature to enable "from left" and […]

You rated this post out of 5. Change rating

2007-08-27 (first published: )

321 reads

Technical Article

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Repor

  • Article

Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined below.

2007-02-08

2,615 reads

Technical Article

Find Text in Database Objects (triggers / stored procedures)

  • Script

I find myself refacoring an existing database which has some inefficient code, like cursors in stored procedures and triggers ...Wanting to figure out which objects contained this "poor" code, I made myself a little script to list all the objects which contain a search string.Just change the value that @search is set to and run […]

5 (1)

You rated this post out of 5. Change rating

2007-03-01 (first published: )

1,172 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

Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY

By Chandan Shukla

Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...

Vector Datatype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Vector Datatype

PRs Are Like Trouble Tickets

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PRs Are Like Trouble Tickets

Visit the forum

Question of the Day

Vector Datatype

The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?

See possible answers