(Kalen Delaney) The sysindexes system table contains information about your index structures that you can’t get through information schema views. Every database has a sysindexes table, which contains one row for every index and one row for every column-based statistics on a table. In general, Mi

(Andre Vigneau) The question is why do you want to know which version of Microsoft SQL Server you’re running? In my case it is for compatibility purposes. Applications or scripts might not always be compatible with older versions of SQL Server. Also in the same way applications or scripts might n

(Steve Warren) I have been thinking about this series for quite awhile and have decided to start my Day to Day DBA (DTDDBA). This series will consist of How-To articles from a beginning perspective and advance as far as I can take it. My goal for this series is to teach you the basics as well as adv

If you try to uninstall SQL Server 6.5 by doing the following after SQL Server 7.0 has been upgraded to SQL Server 2000 on the same computer: On the Start menu, choose Programs, select Microsoft SQL Server-Switch, and then click Uninstall SQL Server 6.x. you may receive the following error messa

Running a certain sequence of commands involving explicit transactions and parameters in an application program using the SQLOLEDB Provider incorrectly leaves an uncommitted transaction open. This can cause severe blocking and other problems.

(Dinesh Asanka) dbMaestro is a database data and formation management tool. Since Software systems are constantly evolving, Database Administrators and senior developers are called for managing and controlling DB changes. (R)

(Marcin Policht) We are continuing our series which covers new and enhanced functionality implemented in SQL Server 2005 (based on its Beta 2 release), focusing on high availability and scalability area. We have presented so far database mirroring and failover clustering – now it is time for other f

(Andras Belokosztolszki) Semantic heterogeneity might sound like a meaningless bit of tech jargon, but it actually describes a subtle set of problems confronting many developers and DBAs. Anyone who’s ever had to combine data sets from two different databases (and what DBA or database developer hasn

The SQL Server 2000 Books Online documentation is incorrect regarding the default value for the @terminate parameter for the sp_change_primary_role stored procedure in the msdb database.

(Eli Leiba) This article describes how to implement a flexible backup strategy for all databases in a given SQL server. All databases are backed up completely or differentially by using a backup strategy control character depending on the database name and the day in the week. The control character