System stored procedure that displays information about database object dependencies.

by Jack Herrington – There are many up-and-coming database access protocols, but exactly what do we need them for? Is it possible that those who would like to replace SQL for being slow should learn to write better SQL?

Since upgrading to SQL Server 2000, I have encountered a problem in SQL Profiler: I am unable to capture parameterized Transact-SQL statements. Instead of the parameter @p1, I want the actual value used in the query execution. How can I place the substitution without referencing other lines in the t

Gray, head of Microsoft’s Bay Area Research Center, sits down with Queue and tells us what type of a voracious appetite for data could require such extreme measures. A recent winner of the ACM Turing Award, Gray is a giant in the world of database and transaction-processing computer systems. Before

by Brad M. McGehee – You are one of a team of developers working on a new internal application that uses SQL Server as its backend. Two of the team members, including yourself, have been assigned the task of database design and maintenance, while four others have been assigned the task of writing th

I’ve noticed a lot of entries in the sysindexes table for indexes that I didn’t create. I heard that they’re not real indexes but statistics that the SQL Server query optimizer has automatically created. How can I tell if an index is “real” or one automatically created by SQL Server?

By Paula Rooney – Microsoft’s Windows Small Business Server 2003 has been released to manufacturing and will officially ship on Oct. 9, Microsoft said.The product, developed under the code name Bobcat, has been redesigned to simplify the installation and deployment for solution providers tha

Senior database researchers gather every few years to assess the state of database research and to recommend problems and problem areas that deserve additional focus. This report summarizes the discussion and conclusions of the sixth ad-hoc meeting held May 4-6, 2003 in Lowell, Mass. It observes th

By Kalen Delaney – Many people break the subject of high availability into two parts—disaster prevention and disaster recovery—and discuss the topic as if every step in a high-availability solution fits neatly into one arena or the other. However, while I was planning for this article and trying to

Here are ten things you can do today to improve the security of your SQL Server installation: