SQL Server performance is dependent on the server resources available and disk performance is probably the most important resource. To maximize disk performance for SQL Server, I've always been told that the drive's partition offset must be set to 32K and the allocation unit size set to 64K for partitions that hold data and 8K for partitions that hold logs. How do I find out the allocation unit size and partition offset for my drives?

Creating Custom Calendars in SQL Server Analysis Services

by Andrew Muyobo

SQLServerCentral.com

Analysis Services (SSAS)

Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.

Hot Skills

by Steve Jones

SQLServerCentral.com

Editorial

What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.

Creating User-Defined Functions in Microsoft SQL Server

by Additional Articles

Database Journal

SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.

Can Wives Shorten Work Hours?

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.

SQL Server's implementation of Window Functions

by Phil Factor

SQLServerCentral.com

Editorial

Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.

Migrating Your SQL Server Database Applications to SQL Azure

by Additional Articles

Database Journal

Azure

Most business applications you write probably utilize some kind of relational database. And, as a .NET developer, the chances are that database is Microsoft SQL Server. This article walks you through migrating your SQL Server database applications to the cloud with SQL Azure.

Great Service – All About Attitude

by Andy Warren

SQLServerCentral.com

Editorial

today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.

Moving Database Files Detach/Attach or ALTER DATABASE?

by Jonathan Kehayias

SQLServerCentral.com

Administration

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.

Mission Critical: SQL Server Upgrade

by Additional Articles

SimpleTalk

upgrading

You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.

Partition offset and allocation unit size of a disk for SQL Server

Creating Custom Calendars in SQL Server Analysis Services

Hot Skills

Creating User-Defined Functions in Microsoft SQL Server

Can Wives Shorten Work Hours?

SQL Server's implementation of Window Functions

Migrating Your SQL Server Database Applications to SQL Azure

Great Service – All About Attitude

Moving Database Files Detach/Attach or ALTER DATABASE?

Mission Critical: SQL Server Upgrade

Blogs

Advice I Like: Rewards from Work

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Analysis Services Model w/ Direct Query and (Default Veritpaq)

Don't Panic

Question of the Day

Identities and Sequences IV