Preface: Jez Marsh is a SolarWinds MVP and the founder of Silverback Systems U.K., a solutions provider working with customers to sharpen their operations processes and maximize their investment in their monitoring solutions. He primarily works with customers to implement SolarWinds network management software and systems management solutions but has found a growing need for […]
Read More
A lot of different factors go into SQL Server® performance, which can make troubleshooting performance problems difficult. However, there are many common SQL Server deployment mistakes that can impact SQL Server performance. In this presentation, you’ll learn about some of the common mistakes that can degrade SQL Server performance and how to avoid them. You’ll […]
Read More
With the added complexity of growing data volumes and ever-changing workloads, database performance tuning is now necessary to maximize resource utilization and system performance. However, performance tuning is often easier said than done. Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise in […]
Read More
As of Oracle Database 11g, you can use the PIVOT and UNPIVOT operators to work with “crosstab” data. In a crosstab report, rows of data are displayed in separate columns. In this query, the second and third columns are the Fred Fuller columns, the fourth and fifth are the Dorah Talbot columns, and so on. […]
Read More
An index-organized table keeps its data sorted according to the primary key column values for the table. An index-organized table stores its data as if the entire table was stored in an index. Indexes serve two main purposes: To enforce uniqueness When a PRIMARY KEY or UNIQUE constraint is created, Oracle creates an index to enforce […]
Read More
Tuning, to a degree, is similar to maintenance. In order to be effective, the effort needs to be continuous. Occasionally you’ll encounter the silver bullet, but these occasions are few and far between. Effective tuning requires routine care involving collecting baselines, removing superfluous tasks, monitoring metrics, modifying parameters or objects, and testing the results. In […]
Read More
Oracle uses an optimizer to determine the most efficient way to perform each SQL command. For INSERT statements, Oracle tries to insert each new record into an existing block of data already allocated to the table. This execution plan optimizes the use of space required to store the data. However, it may not provide adequate […]
Read More
The USER pseudo-column is quite useful when you are using remote data access methods. For example, you may not want all remote users to see all rows in a table. To solve this problem, you must think of remote users as special users within your database. To enforce the data restriction, you need to create […]
Read More
If you are a user in the LOCAL database shown in Figure 1, you can access objects in the REMOTE database via a database link. To do this, simply append the database link name to the name of any table or view that is accessible to the remote account. When appending the database link name […]
Read More
In addition to running the data load processes at off-peak hours, you can take other steps to improve the load performance. The following steps all impact your overall database environment and must be coordinated with the database administrator. The tuning of a data load should not be allowed to have a negative impact on the […]
Read More
In addition to the traditional options for tuning a workload using the File or Table choice, which allows you to specify a script or a table containing the T-SQL statements to tune, starting with SQL Server 2012, you can also specify the plan cache as a workload to tune. In this case, the DTA will […]
Read More
Over an application’s lifespan, its data very likely will move from one database to another or from one host to another. Therefore, it will simplify application maintenance if the exact physical location of a database object is shielded from the user (and the application). The best way to implement such location transparency is through the […]
Read More