Articles

SQLServerCentral Article

Reattaching Databases - Some Code AND a Contest!

Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!

You rated this post out of 5. Change rating

2001-09-04

6,463 reads

SQLServerCentral Article

Try the SQL Parser Object to Colorize your SQL!

The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.

5 (1)

You rated this post out of 5. Change rating

2001-08-31

8,104 reads

External Article

SQL Server 2000 User-Defined Functions White Paper

The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.

2001-08-31

2,233 reads

Technical Article

INF: Understanding How to Configure a SQL Server Connection Affinity

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.

2001-08-28

1,500 reads

SQLServerCentral Article

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

You rated this post out of 5. Change rating

2001-08-27

3,296 reads

Blogs

Stack Overflow & AI

By

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...

Checking Myself with GenAI

By

I had a suggestion from somone on a place where AI helps them and...

Redgate SQL Prompt in SSMS 21

By

Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...

Read the latest Blogs

Forums

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Does Version Control Scare You

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Does Version Control Scare You

Unlimited Text

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unlimited Text

Visit the forum

Question of the Day

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

See possible answers