SQLServerCentral Article

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!

SQLServerCentral Article

Replication's Horizontal and Vertical Partitioning Capabilities

There are times that you may find yourself on a project where you have one data source and need to publish to many subscribing databases. Often times, Replication is not looked at as a viable solution to achieving this goal. For this project, Demico and Lynn will demonstrate the way we utilized the Horizontal and Vertical partitioning capabilities that Microsoft has added to the Replication utility.

SQLServerCentral Article

Using Exotic Joins in SQL - Part 2

In the previous article, you saw how the BETWEEN operator could be used in joins to solve problems dealing with range-based data. In this article, Chris Cubley will show you how to take joins even further by using multiple criteria in joins as well as using the greater than, less than, and not equals operators in joins.

Blogs

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Build Recovery into the Design

By

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

Read the latest Blogs

Forums

Serverless Gets Faster

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Serverless Gets Faster

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

How

By cw255

Hi, wondering if someone can help me. We're trying to build an application that...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers