Support for Network Database Files
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
2001-09-14
1,145 reads
Additional Articles
Microsoft SQL Server OLAP Services Cell-Level Security
This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.
2001-09-13
1,358 reads
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
2001-09-11
1,661 reads
SQL Server Database Coding Conventions and Best Practices
Learn the key basics of writing quality Transact-SQL code.
2001-09-07
6,666 reads
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
50 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers