Fabiano Amorim

Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe...

20 February 2014 10 min read

Dwain Camps

Gaps in Overlapping Time Intervals in SQL Server: Packing Intervals and Finding Inactivity

Finding gaps of inactivity between overlapping time intervals in SQL Server - packing overlapping login, event, or occupancy periods into...

14 February 2014 21 min read

David Njoku

Oracle for Absolute Beginners: Part 3 – Update, Insert, Delete

Part 1, Part 2. A wise man* once said: So no-one told you life was gonna be this way. Your...

13 February 2014 10 min read

David Tate

Guerrilla Project Management for DBAs

All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract...

13 February 2014 27 min read

Learn SQL Server

Jes Borland in Learn SQL Server

SQL Server Indexed Views: What They Are and How to Create Them

SQL Server indexed views persist query results as a physical clustered index, making complex aggregations and joins fast for repeated...

12 February 2014 24 min read

Joe Celko

SQL Server SEQUENCE Basics

The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is...

06 February 2014 13 min read

Patrick Barel

Result Cache (Part 2)

Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we...

04 February 2014 5 min read

Nirmal Sharma

Hosting SQL Server in Hyper-V Replica Environment

A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the...

04 February 2014 26 min read

Patrick Barel

Result Cache (Part 1)

First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things...

28 January 2014 5 min read

Feodor Georgiev

Collect Your SQL Server Auditing and Troubleshooting Information Automatically

If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of...

28 January 2014 12 min read

Joe Celko

Nesting Levels in SQL

The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way...

27 January 2014 13 min read

Robert Sheldon

The SQL Server Sqlio Utility

If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware's...

27 January 2014 14 min read

Dwain Camps

The Performance of the T-SQL Window Functions

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there...

17 January 2014 16 min read

Gail Shaw

SQL Server Deadlocks: Types, Causes & Prevention Guide

Complete guide to SQL Server deadlocks with reproducible examples. Covers bookmark deadlocks, key-range deadlocks, cascade deadlocks, deadlock graphs, DEADLOCK_PRIORITY, and...

16 January 2014 55 min read

Hugo Kornelis

Generating Test Data in TSQL

To test SQL, you need test data. There are usually many reasons why you can't use production data. Although it...

14 January 2014 30 min read

David Njoku

Oracle for Absolute Beginners: Part 2 – SQL

A wise man* once said, no one’s ever learned how to cook just by reading recipes. And so, since we...

13 January 2014 13 min read

Laerte Junior

Reading SQL Server Error Logs and Windows Event Logs with PowerShell – Get-EventLog and SQLPSX Filtering

Reading and filtering SQL Server Error Logs and Windows Event Viewer logs with PowerShell - Get-EventLog for the Windows event...

10 January 2014 32 min read

Dev Nambi

Agile Database Development

Agile methodologies work well with database developments only if great care is taken to do things right. It requires good...

03 January 2014 28 min read

Robert Sheldon

The SQL Server Sqliosim Utility

The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It doesn't...

02 January 2014 14 min read

Dwain Camps

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the...

17 December 2013 12 min read

Register for Simple Talk

Databases

Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

Gaps in Overlapping Time Intervals in SQL Server: Packing Intervals and Finding Inactivity

Oracle for Absolute Beginners: Part 3 – Update, Insert, Delete

Guerrilla Project Management for DBAs

SQL Server Indexed Views: What They Are and How to Create Them

SQL Server SEQUENCE Basics

Result Cache (Part 2)

Hosting SQL Server in Hyper-V Replica Environment

Result Cache (Part 1)

Collect Your SQL Server Auditing and Troubleshooting Information Automatically

Nesting Levels in SQL

The SQL Server Sqlio Utility

The Performance of the T-SQL Window Functions

SQL Server Deadlocks: Types, Causes & Prevention Guide

Generating Test Data in TSQL

Oracle for Absolute Beginners: Part 2 – SQL

Reading SQL Server Error Logs and Windows Event Logs with PowerShell – Get-EventLog and SQLPSX Filtering

Agile Database Development

The SQL Server Sqliosim Utility

Calculating the Median Value within a Partitioned Set Using T-SQL