(Sean Hull) If you are new to databases, or perhaps new to Oracle, you may find the discussion on indexes and indexing strategy complicated. Don’t fret. To get started it’s fairly straightforward, and as long as you pay attention to the options relevant to day-to-day dba needs, it should remain fa
Other News
Find size of SQL Server tables and other objects with stored procedure
(Richard Ding) Sp_spaceused is a stored procedure that ships with SQL Server and is used to display the disk space taken by a SQL Server object. Very often, I find it inadequate to meet my intentions. For instance, when I want an overview of user table sizes in a given SQL Server database, or wish t
ASP.NET 3.5 Extensions Preview – AJAX History Management
(Mina Shawky) ASP.NET 3.5 Extensions Preview is now gaining more attention and a lot of articles are being submitted in order to discuss different enhancements and new additions to the ASP.NET API. One of the very good enhancements has to be with the ASP.NET AJAX and the ability to manage and record
Introducing OpenDocument
(Uche Ogbuji) The OASIS Open Document Format for Office Applications (ODF) is an XML standard that lets you store and exchange office application documents, including word-processor, spreadsheet, and presentation files. Whether you try to perform special tasks on files saved from such applications o
ASP.NET Tips: Getting SOS to work when commands fail
(Tom) So the last quiz asked about a common error message you may see when debugging a dump from .NET on a machine other then where the dump was captured. Now I want to go into more detail on this.
Using LINQ to SQL in an ASP.NET Application
(Stephen Walther) Most of the blood, toil, tears, and sweat that an ASP.NET developer experiences while building a web application is associated with writing the data access code. Microsoft introduced LINQ to SQL with .NET Framework 3.5 to reduce the work that a developer must perform when accessing
Implementing a Left Join with LINQ
(Paul Kimmel) Oddly enough, LINQ doesn’t define keywords for cross join, left join, or right join. As part of the LINQ grammar, you get join and group join. Joins can be equijoins or non-equijoins. An equijoin uses the join keyword and non-equal joins are contrived using where clauses. However, left
SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
(David Leibowitz) One of the largest changes in SQL Server 2008 Reporting Services (SSRS) is that it no longer relies on IIS. Due mostly to feedback from end users on security (most do not like to keep web hosts active on their database servers), the added benefits include reduced memory requirement
Interesting observation with table > 1TB
(Kevin Cox) We have a project using SQL 2005 with a table that is several terabytes. This table has a varbinary(max) column with an average length of 150k bytes.
Information architecture essentials, Part 6: Distributed data mining
(Benjamin Lieberman) One of the most interesting challenges for information architects is the situation in which large, proprietary, widely distributed data stores are necessary to address a specific research question. Learn about the difficulties involved in mining distributed data sources and the