SQL Server Database Coding Conventions and Best Practices
Learn the key basics of writing quality Transact-SQL code.
2001-09-07
6,666 reads
Additional Articles
Measure for Measure
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
2001-09-06
1,614 reads
What is OLAP?
An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.
2001-09-05
1,422 reads
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
OLAP Services: Managing Slowly Changing Dimensions
Amir Netz is one of the true OLAP and SQL Server gurus at Microsoft. If you ever get the chance to see him speak, go. This is one of his articles examining OLAP services.
2001-08-30
2,324 reads
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
SQL Insider Freeware Software to Become Openware
Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
2001-08-27
48 reads
The Self-Taught DBA
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
2001-08-24
4,429 reads
Strategies for Backing Up and Restoring Transactional Replication
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
2001-08-21
2,176 reads
The Ultimate SQL Server
From a DBA's point-of-view, the bigger the SQL Server box, the better. What would you consider to be the ultimate SQL Server box?
2001-08-10
1,628 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers