XML Data Solutions

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

Information Schema Views

SQL Server DBAs are often curious about the inner-workings of SQL Server. Indeed, it can save your job during disasters to know what's going on inside SQL Server. This article shows you how to use some of the SQL Server internal views to view some meta data about your servers.

Blogs

Unit Testing & Intelligent Query Processing

By

Actually, these two topics don’t have anything to do with one another. I just...

Daily Coping 31 Mar 2010

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Replaying Workloads to a different Database

By

One of the features I was asked to implement for WorkloadTools is the ability...

Read the latest Blogs

Forums

SSRS report font settings

By Tomys

Dear team, Hope all are safe and doing well, We have a Windows Server...

How to find Last Record with multiple results

By dzirkelb

In Access, there is a LAST function, which simply allows you to do a...

Arithmetic overflow error converting expression to data type nvarchar.

By cbrammer1219

Is there a way to find the field this error is being generated by?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Cloud Time

See possible answers