Skip to content
Free planNo credit card requiredStart writing
AI for Research home
AI for Research home
Dashboard
Sign inGet started

Search 250 million research papers

Read the abstract, see who wrote it and who cites it, and get the citation in APA, MLA, Chicago or Harvard.

About 808 papers for “SQL Server 2008”

SQL server 2008

Charte Ojeda, Francisco · Virtual Defense Library (Ministerio de Defensa) · 2009

Cited by 0

Essential SQL on SQL Server 2008

Sikha Bagui, Richard Earp · 2009

This book, written for readers who have little or no previous experience with databases, SQL, or SQL Server, provides a very systematic approach to learning SQL (Structured Query Language) using SQL Server. Each chapter is written in a step-by-step manner and has examples that can be run using SQL Server. Using the sample tables and data provided, the reader of this book will be able to do all the examples to experience hands-on SQL programming in SQL Server. The text also presents a series of exercises at the end of the chapters to help readers gain proficiency with SQL. With this book you will learn: Beginning SQL commands how to retrieve and manipulate data using the simple SELECT statement. How to customize SQL Server 2008 s settings and about SQL Server 2008 s functions. How to create, alter, populate and delete tables. About joins, a common database mechanism for combining tables. Query development, the use of views and other derived structures. Simple set operations. About aggregate functions. How to write subqueries and correlated subqueries. How to create and use indexes and constraints. Transaction processing.

Cited by 1

Configuring SQL Server 2008

2009

This Chapter contains sections titled: Configure the Server Platform Configure SQL Server 2008

Cited by 0

Accelerated SQL Server 2008

Robert E. Walters, Rae, Robert, Ferracchiati, Fabio et al. · Apress eBooks · 2008

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the

Cited by 0Open access

Microsoft SQL Server 2008 T-SQL Fundamentals

Itzik Ben-Gan · CERN Document Server (European Organization for Nuclear Research) · 2008

This book walks you through your first steps in T-SQL (also known as Transact-SQL), which is Microsoft SQL Server s dialect of the standard ANSI-SQL language. You ll learn the theory behind T-SQL querying and programming, how to develop T-SQL code to query and modify data, and get an overview of programmable objects. Although this book is intended for beginners, it is not merely a step-by-step book. It goes beyond the syntactical elements of T-SQL and explains the logic behind the language and its elements. Many aspects of SQL are unique to the language, and are very different from other programming languages. This book helps you adopt the right state of mind and gain a true understanding of the language elements. You learn how to think in terms of sets and follow good SQL programming practices. The book is not version-specific; it does, however, cover language elements that were introduced in recent versions of SQL Server, including SQL Server 2008. To complement the learning experience, the book provides exercises that enable you to practice what you ve learned. The book starts with a theoretical background to T-SQL querying and programming (Chapter 1) laying the foundations for the rest of the book, and also coverage of creating tables and defining data integrity. The book moves on to various aspects of querying and modifying data (Chapters 2 through 8), then to a discussion of concurrency and transactions (Chapter 9), and finally provides an overview of programmable objects (Chapter 10). This book features a companion Web site that makes available to you all the code used in the book, the errata, additional resources, and more.

Cited by 10

SQL Server 2008 Reporting Services

Apress eBooks · 2008

As a beginner learning how to use SQL Server 2008, the final piece of the jigsaw puzzle is discovering how to retrieve data from a database and place it on a report. Various reporting tools inhabit the marketplace. Some, such as the Business Objects stable of products, are very powerful, but they’re generic tools that cater to many different data sources. Microsoft has produced its own reporting tool, Reporting Services, which is becoming more and more powerful with each version. The aim of this chapter is to introduce you to Reporting Services so you can see some of what is achievable.KeywordsServer InstanceJigsaw PuzzleReporting ServiceReporting ToolConfiguration ToolThese keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Cited by 0

Installing Microsoft SQL Server 2008

Apress eBooks · 2009

The past two chapters discussed which edition of SQL Server 2008 to install, identifying and selecting the hardware requirements, and figuring out the high-availability solution to implement, if any. In an effort to help stimulate thought and effort into planning the installation of your system, there was an adequate amount of information presented. You have finally reached the point where you can validate your pre-installation considerations and install SQL Server 2008. There are three installation methods discussed throughout this chapter: Installing SQL Server using the GUI version of setup.exe Installing SQL Server from the command line Installing SQL Server using a configuration file KeywordsOptional ParameterCommand LineConfiguration FileInstallation ProcessDatabase EngineThese keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Cited by 4

Microsoft SQL Server 2008 Internals

Kalen Delaney, Paul Randal, Kimberly Tripp et al. · CERN Document Server (European Organization for Nuclear Research) · 2009

Explore the definitive guide to the internals and architecture of the Microsoft SQL Server 2008 relational database engine. The author an expert on SQL Server internals offers the guidance developers and database administrators need to understand how SQL Server internal structures affect application development and functionality. Get the practical guidance needed to understand and maximize the SQL Server architecture, including information about logging and recovery, indexes, tables, transactions and locking, and security. This complete reference offers numerous code samples, table examples, and practical advice.

Cited by 16

Expert SQL Server 2008 Development

Alastair Aitchison, Adam Machanic · Apress eBooks · 2009

Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer Alastair Aitchison shows you how to think about SQL Server deve

Cited by 0Open access

Pro SQL Server 2008 XML

Coles, Michael · CERN Document Server (European Organization for Nuclear Research) · 2008

Cited by 0

Pro SQL Server 2008 XML

Michael Coles · Apress eBooks · 2008

Knowledge and ability to apply XML are de rigueur in today's world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the pow

Cited by 0Open access

Pro SQL Server 2008 Administration

Simmons, Ken, Carstarphen, Sylvester · CERN Document Server (European Organization for Nuclear Research) · 2009

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server. *Introduces new administration features of SQL Server 2008 *Shows how to manage a SQL Server 2008 database at professional level *Provides guidance on performance optimization What you'll learn*Take advantage of the new administrat

Cited by 0

مرجع کامل SQL Server 2008

مولف رابرت ویئیرا · 2016

مرجع کامل SQL Server 2008 , مرجع کامل SQL Server 2008 , مرکز فناوری اطلاعات و اطلاع رسانی کشاورزی

Cited by 0

Menguasai T-SQL Query + Programming SQL Server 2008

Aryo Nugroho, Widyo Hermawan · 2009

SQL Server 2008 merupakan RDBMS (Relational Database Management System) yang powerful untuk mengolah data. Pada versi baru SQL Server 2008, T-SQL sudah memiliki banyak peningkatan.

Cited by 0

Pro SQL Server 2008 Failover Clustering

Allan Hirt · 2009

Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a singleinstance, twonode cluster or a multiplenode, manyinstance cluster for consolidation, this book will detail all of the considerations and pitfalls that may be encountered along the way. Clustering and highavailability expert Allan Hirt shares his many years of wisdom and experience, showing how to put together the right combination of people, processes, technology, and best practices to create and manage worldclass, highly available SQL Server 2008 failover clusters. Provides a comprehensive look at SQL Server 2008 failover clustering from the first steps of planning to daily administration Goes beyond just SQL Server 2008 and also covers Windows Server 2008 clustering in depth with a SQL Server focus Covers how and where virtualization can be used with failover clusters Addresses the needs of enterpriseclass, 24/7 SQL Server 2008 implementations Written by the leading expert on SQL Server failover clustering What youll learn Understand what failover clustering is, how it works, and how it can benefit SQL Server deployments. Configure disk subsystems to support failover clustering implementations. Plan, implement, and administer Windows Server 2008 clustering for use with SQL Server 2008. Plan, implement, and administer new SQL Server 2008 failover clustering instances. Upgrade existing SQL Server 2000 and SQL Server 2005 failover clustering instances to SQL Server 2008. Create virtualized clusters for use in test and development environments. Who is this book for This book is for IT administrators and DBAs who are faced with implementing and administering clustered SQL Server 2008 instances. This book is also for those who will be upgrading existing SQL Server 2000 or SQL Server 2005 failover clustering instances to SQL Server 2008. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hardwon solutions to problems you will face in your professional programming career.

Cited by 0

Tablas Recursivas en SQL Server 2008

Arias, Eddy, Gutiérrez, Harold, Cruz, Erick et al. · Repositorio Universidad Nacional Autonoma de Nicaragua-Managua (Universidad Nacional Autonoma de Nicaragua Managua) · 2014

La recursión o recursividad, nos explican (Cairó & Guardati, 2006):es un concepto amlio, con muchas variantes, y difícil de precisar con pocas palabras. Aparece en numerosas actividades de la vida diaria por ejemplo, en una fotogtafía donde se observa otra fotografía

Cited by 0