Improve System Performance in Your Indexing Scheme Using Asynchronous
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
Additional Articles
Transactional Replication Performance Tuning and Optimization
This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. (30 printed pages)
2001-10-08
1,868 reads
COM+ Application Guidelines for Visual Basic Development
This 80-page reference article presents guidelines for designing, building, and deploying COM+ applications, with an emphasis on Visual Basic.
2001-10-05
879 reads
Pre-Sliced Peanut Butter
Pre-sliced peanut butter is on its way to U.S. store shelves in test markets - fact or fiction??
2001-10-02
758 reads
SQL Spy Releases as OpenSource
Download the source code today for a great method for SQL Server live monitoring.
2001-10-01
58 reads
Using AWE Memory in SQL Server 2000
Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.
2001-09-27
1,009 reads
2001-09-26
3,387 reads
Managing Spatial Information with SQL Server
You already know how to use SQL Server to manage your core business data, now learn how to leverage this knowledge to manage your "spatial" data.
DATE: September 25, 2001
TIME: 2:00pm ET, 6:00pm GMT
DURATION: 40 minutes, including questions & answers at the end
With SpatialWare for SQLServer, you now have the ability to manipulate spatial objects and store them inside of SQL Server allowing you to share information across the enterprise.
2001-09-24
52 reads
SQL Server Security Best Practices
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
DBCC SQLPERF (Logspace) Reporting Internals
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
Blogs
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers