The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Exclusive interview: Microsoft VP of SQL Server Gordon Mangione explores why customers aren't applying patches and what Microsoft is doing about it. Also, learn the basics of .NET connection pooling, how to monitor SQL Server memory utilization, and more!
By Brian Moran
Both ISQL and xp_sqlmaint are particular about whether parameters are enclosed in single and double quotes. Find out if using the -i switch is a suitable option for you.
See one of the few cases where an embedded space between a parameter and its value is absolutely required.
By Michael Otey
One aspect of database performance that's rarely considered is the OS itself, which ultimately handles all I/O requests.
By Itzik Ben-Gan
A histogram is a simple means of gathering statistics for analysis. But what's the best way of generating histograms?
By William Vaughn
If you’re diving into ADO.NET, you might be wondering how you can use connection pooling to improve your applications’ performance. Here are some basic connection-pooling concepts you’ll need to know when you’re ready to get your feet wet.
By Kalen Delaney
With just a few counters and a little experience, you can monitor and manage your SQL Server memory.
By
Microsoft's SQL Server development team takes a close look at a query that works from the inside out to return information from tables that are related only indirectly.
In the aftermath of the Slammer worm, Microsoft Vice President of SQL Server Gordon Mangione explores why customers aren’t applying patches, shares how Microsoft plans to solve these problems, and looks to the future of security for SQL Server.
When you delete rows, pages, or extents, SQL Server can mark those objects as "ghosts" and clean them up later. Here's how one DBA unearthed these ghostly objects while investigating a mysterious error code.
Have you noticed entries in the sysindexes table for indexes that you didn't create? Read on to find out what these entries are for.
How can I keep SQL Server 7.0 from truncating varchar data?
By Rich Rollman
You’ve stored open content from your XML document in your database. Now you need to merge the content with relational data in an XML query result. Read on to see how you can use FOR XML Explicit queries and XML Views to return the open content.
By Michelle A. Poolet
“A rose by any other name would smell as sweet,” but when you change a database object’s name, you can create confusion and poor performance. Here are some tips for choosing and using a good naming convention.
ADO.NET isn’t just a fancy new wrapper for the COM-based version of ADO. Here are seven tips to help you write better ADO.NET applications.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
Readers ask why so many SQL Servers were connected to the Internet--where they were vulnerable to Slammer, whether linked servers work for Oracle running on Solaris, and comment on choosing a .NET language.
Find out what your options are when determining the port number a SQL Server instance is using.
advertisement