Tag Archives: SQL

SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between. Our articles are written by real DBAs and developers, based on the articles and scripts they use in their daily

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the Query Optimizer of SQL Server's Database Engine to translate the 'logical' SQL Query into the best strategy for doing all the physica

In just 24 sessions of one hour or less, you'll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you'll

Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL wi

Windows Azure SQL Reporting provides a flexible platform for managing and viewing reports. Its cloud-based architecture means that its services are instantly scalable for any number of users - adding and removing servers through Windows Azure is sign

Whether you're a database designer, programmer, analyst, or manager, you've probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it d

SQL: A Comparative Survey is a companion to Hugh Darwen's An Introduction to Relational Database Theory, best studied in parallel with that text. Closely following the structure of the theory book, it shows how the examples in that book can be expres

SQL is a standard language for storing, manipulating and retrieving data in relational databases.You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do

This book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. My purpose of writing this was to provide a gentle tutorial on the syntax of SQL, so th

SQL is the language of data, and therefore the intermediary language for those who straddle the line between technology and business. Every business application needs a database and SQL is the key to working with these databases. This book will show