SSIS Events and Handlers
Explore how SQL Server 2008 Integration Services' events are triggered during package execution and the ability to react to their outcome through event handlers.
Partition offset and allocation unit size of a disk for SQL Server
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
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
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
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?
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
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
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
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?
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers