OpenXML.exe demonstrates how to retrieve an ADO Recordset from an input XML document by using the OpenXML feature in SQL Server 2000.
Tag: sql server
Backup and Restore – Back to Basics with SQL LiteSpeed
This article by Greg Robidoux provides some great information about SQL LiteSpeed. One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. Sev
Determine the number of rows in a table without a table scan
By Andrew Novick – If you don’t require an exact answer, it isn’t necessary use a SELECT count(*) query on the rows in a table to get the row count. SQL Server keeps the row count in sysindexes and it can be retrieved there. The key is to select the correct record from sysindexes.
Book Excerpt: SQL: The Complete Reference, Second Edition
Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and u
Slammer Source Code Provides Clues
By Dennis Fisher – Although still unclear on who unleashed the worm onto the Internet, security experts say signatures in the worm’s code indicate a Chinese cracking group may be responsible for writing the code.
How to Search for Date and Time Values Using Microsoft SQL Server 2000
by Bryan Syverson – Learn how to perform searches on date and time columns. Includes some tips on performance.
Who Needs Change Management
Have you ever found yourself in this situation? Something gets changed and you don’t know about until there’s a problem. Or someone makes a change and says “Don’t worry it’s a small change. No one will even notice.” I think we have all found ourselves in these situations. This article discusses some
Top 10 SQL Server security blunders, part II
By Jan Stafford – A security breach is never pretty. When a hacker gets into a database, however, things get downright ugly.
Using Transact-SQL to Count SQL Server Processors
How can I use Transact-SQL to programmatically determine the number of processors that my SQL Server computer has?The following statement will return the information you need:
How Using the Windows 2000 Encrypted File System to Secure SQL Server Databases and Backups Affects SQL Server’s Performance
by Chris Kempster – While Windows 2000’s encrypted file system option provides needed security, how does it affect SQL Server’s performance?