2001-11-02
1,265 reads
Additional Articles
XML for SQL Server 2000: Optimizing Your Performance
The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.
2001-11-01
2,241 reads
SQLXML 2.0 (XML for SQL Server 2000)
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
2001-10-29
6,623 reads
Query to Display Trigger Status
Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]
2001-10-28
1,375 reads
2001-10-26
1,436 reads
Microsoft Analysis Services Trounces the Competition
Microsoft has the #1 OLAP product according to a new survey from Survey.com
2001-10-25
4,539 reads
Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
New Certification - MS System Administrator
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
2001-10-18
1,223 reads
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
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
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Need to overload tempdb
Yes, you read that title correctly. I have a somewhat hilarious problem. We have...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers