atabase Tuning Advisor (DTA), the SQL Server 2005 replacement for the Index Tuning Wizard (ITW), has two entry points: A GUI that practically drives itself A command line interface with
emoving extra empty spaces is a pretty common task that seems very simple, but in reality it is not as trivial as you may assume. The first impulsive solution that
rocessing text or long strings in SQL has never been an easy task. SQL is a powerful language for performing fast operations on data sets, but when it comes to
ince its first release, Microsoft SQL Server Reporting Services (SSRS) has supported a plethora of data sources. Out of the box, its data modules, called data extensions, allow you to
racle recently released version 1.0 of SQL Developer, its free PL/SQL development IDE. Formerly known as Project Raptor, Oracle SQL Developer is based on the same IDE platform as JDeveloper
atabase performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence,
n index on a computed column can boost your SQL Server query’s performance or even implement a complex business rule. (Computed columns do not store their own values; their values
hen I was writing code for user interfaces, I needed to present data in different ways. Logically it wasn’t difficult, but since the presentation layout was often quite different from
n our increasingly interconnected world, it’s more and more important for code to be able to handle time zones gracefully. For example, if call centers in Bangalore and London use