Standard Members

Pro Members SQL Server Standard Members

Tips for using views in SQL Server 2012

by

Tips for using views in SQL Server 2012 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Consider using indexed views. Indexed views...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Running Oracle Database on Oracle VM VirtualBox

by

Running Oracle Database on Oracle VM VirtualBox By Yuli Vasiliev This article covers how you might evaluate Oracle Database coming with the Database App Development VM appliance that installs on Oracle VM VirtualBox. This appliance includes Oracle Linux as the operating system, and a number of some other Oracle products pre-installed on it, including Oracle Database, allowing you to run...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1)

by

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1) Author: Basit A. Farooq Editor’s Note: This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In this article series, I will first discuss how to design and implement logical multidimensional solution architecture. After that, I will explain the design considerations for online...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Preparing for Database Application Design Reviews

by

Preparing for Database Application Design Reviews By Craig S. Mullins Design reviews are an important facet of the system development lifecycle for database applications. It is imperative that all database applications, regardless of their size, participate in some form of design review both before and after implementation. Design reviews are critical for ensuring that an application is properly designed to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using Very Large Databases in SQL Server 2012

by

Tips for using Very Large Databases in SQL Server 2012 Use distributed partitioned views to partition tables horizontally across multiple servers. By using distributed partitioned views you can greatly improve the very large database performance. Turn off the "automatically grow file" and "auto shrink" options for your very large database. Autogrowing and autoshrinking result in some performance degradation, therefore you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server index related dynamic management views and functions – (Part 3)

by

SQL Server index related dynamic management views and functions – (Part 3) By Basit A. Farooq Editor’s Note: This is the part-3 of this three part article series on index-related dynamic management and functions. In this part, I’ll be covering following index-related dynamic management views (DMVs) that are helpful to find missing indexes inside databases. Introduction: With the release of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
DB2 Pro Members Standard Members

SELECT from INSERT, DELETE, UPDATE, and MERGE

by

SELECT from INSERT, DELETE, UPDATE, and MERGE By Craig S. Mullins A somewhat under-utilized feature of DB2 SQL provides the ability to SELECT from INSERT, DELETE, UPDATE, and MERGE statements. This capability was introduced to DB2 for z/OS over two versions: version 8 and version 9. SELECT from INSERT was introduced with DB2 V8, the remaining with V9. Let’s start...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 file and filegroups

by

Tips for using SQL Server 2012 file and filegroups Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these new features, but usually using them provides more easy and effective way to accomplish the same goal. For example, Microsoft introduces SQL Server FILESTREAM technology that enables SQL Server-based applications to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for Minimizing Deadlocks

by

Tips for Minimizing Deadlocks By Basit A. Farooq The Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases the likelihood of conflicts because multiple processes can request access to same resources at the same time. This type of conflict is also known as block or blocking. The blocking usually...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Five Follow-Up Steps for an Important Interview

by

Five Follow-Up Steps for an Important Interview Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve WynKoop and I talk about designing and managing our professional careers on a weekly interview on SSWUG.org. This...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 91 92 93 94 95 … 110