Infrastructure Planning for a SQL Server Data Warehouse

In this tip we look at some things you should think about when planning for a SQL Server data warehouse.

Best design for OLTP tables

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.

Natively Compiled Stored Procedures with SQL Server 2014

With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.

SQL Server 2014 In-Memory OLTP Architecture and Data Storage

Microsoft is releasing SQL Server 2014 with a new set of In-Memory OLTP features to significantly improve the OLTP performance and reduce the processing time for servers with a large amount of memory and multi-core processors. Check out this tip to learn more.

Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton

In order to take full advantage of the In-Memory OLTP options in SQL Server 2014, you should migrate standard stored procedures that references Memory-Optimized tables to natively compiled ones. In this tip we will see how to achieve this goal.

Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimized 'Hekaton' technology, but how you balance between disk tables and in-memory tables for optimum performance requires judgement and experiment.

A Reporting System Architecture

This article describes one method of implementing a reporting system in SQL Server 2005

RE: Alert is not triggered

Is there a reason that you are using a severity level of 1. Severity levels less than 11 are for informational purposes and this may be causing some of the things that you are seeing. The 16 in your Raiserror is where the <state> goes. This <state> does not seem to do much. I hope this helpsEric 

Sending mails using DTS

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!