Database

Help! My SQL Server Log File is too big!

Overgrown transactional log files can turn into real problems if they are not handled properly. This article discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. Read more »

Move SQL Tuning Sets between Oracle instances

SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing. Read more »

Audit data using SQL Server 2005's COLUMNS_UPDATED function

This article looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Read more »

New Date Datatypes in SQL Server 2008

SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres how you can use these new data types to your advantage in SQL Server 2008. Read more »

Gather query tuning data via Oracle's dynamic performance views

The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS. Read more »

Tags: oracle, sql, views

Using Mirrored Media Sets in SQL Server 2005

Mirrored Media Sets is a new feature in the Enterprise Edition of SQL Server 2005. It enables the creation of redundant copies of a backup file to reduce the possibility of a backup device malfunction. Here's how you make it work. Read more »

Running totals in SQL Server queries

This article demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements. Read more »

Moving the Tempdb and Master Database in SQL Server

This article walks you through the process of moving the Master and Tempdb databases to different drives. Read more »

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how. Read more »

Capturing SQL Server 2005 database file size information

It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Microsoft prescribes more REST

    Details have begun to emerge about the next versions of Visual Studio and Windows Server this week -- and the message from Redmond is to REST up Read more »

    -- posted by Staff

  • Chris Duckett .NET looks to REST

    With news that REST will play a big part in the next version of the .NET Framework, it is timely to take a look at ADO.NET. Read more »

    -- posted by Chris Duckett

  • Renai LeMay Spellr.us needs a new dictionary

    One of the only Australian start-ups to present at the recent round of conferences in the US was Sydney-based spellr.us, which has launched a Web-based tool to check and monitor websites for spelling mistakes. Read more »

    -- posted by Renai LeMay

What's on?