You can also use a CHAR(1). A little more flexibility than bit, but then it has a little more flexibility than bit.

ANSI_DEFAULTS

ANSI_NULLS

ANSI_PADDING

ANSI_WARNINGS

CONCAT_NULL_YIELDS_NULL

From MSDN

How old is the backup? Has more data been added to either database? Has either one had statistics updated or indexes rebuilt? Are you using identical parameters inside the queries...

Yes you may.

It's simply another backup, but it doesn't affect the chain of log backups and differential backups which are based on the last full backup.

To use it, simply...

Kalen is a lady.

According to BOL, An index can be rebuilt with ALLOW_PAGE_LOCKS set to off, but it can't be reorganized.

It's not recommended to mess with the locking mechanisms...

Except when dealing with Oracle structures & data, we actually try to stay away from odd ball abbreviations. It's so much easier to understand what 'DeductibleRate' is versus 'DdltblRt.' Our...

Jeff, after you install the hand rails, you'll also need one of these:

Statistics & data distribution yes, but CPU, memory and disk I/O are also taken into account (although not I/O speed). You also have to deal with parallelism as a factor....

Costs are an estimated value base on a baseline machine from back in the 90's. They're extremely arbitrary and subject to all sorts of vagaries around the statistics of the...

That's a little bit fast. It's based on a cleanup process that starts with the complexity of the plan. The simpler the plan, the lower the complexity number, therefor the...

It still sounds like a permissions problem.

INT will sort faster then DATETIME but not radically faster. Have you updated the statistics on the index recently, maybe with a full scan. Is there a good data distribution...

The procedure cache can and does change. Procedures age out of cache as they are not accessed. It's a pretty normal part of the process.

If I understand the code and the explanation, I think you can change this to use a single pass through one cursor. Instead of a set of SELECT statements and...

Loading the output from a procedure into a temp table and then joining that temp table with your other tables is a good approach. As was noted, if you only...