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
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,426 reads
2001-10-26
1,436 reads
Microsoft has the #1 OLAP product according to a new survey from Survey.com
2001-10-25
4,539 reads
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
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
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
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
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 is on its way to U.S. store shelves in test markets - fact or fiction??
2001-10-02
758 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers