Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.
2009-05-01
2,535 reads
The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.
2009-04-30
1,941 reads
Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.
2009-04-30
2,034 reads
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling.
2009-04-29
2,116 reads
SQL Server 2008 features several replication improvements, and some are more compelling than others. Learn what's new with peer-to-peer topologies, merge replication and more.
2009-04-29
2,855 reads
The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?
2009-04-28
2,670 reads
Fast analysis, better insight and rapid deployment with minimal IT involvement: these are among the benefits of in-memory analytics, but different products are appropriate for different environments. Read our in-depth report on in-memory technologies.
2009-04-28
2,316 reads
I was a running a routine query using an equal operator on the only column of the primary key for a table and I noticed that the performance was terrible. These queries should have been flying because all I was doing was retrieving one row of data which should have been doing an index seek. When I looked at the query plan it was doing a scan instead. This tip shows you what I found and how to resolve the problem.
2009-04-27
3,197 reads
Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.
2009-04-27
2,488 reads
Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
2009-04-24
2,532 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers