Having been there a couple of times over the years, I was glad to see this in writing. Igt is a fact of life, that sometimes you cannot use the...

It has been ours aw well. It appears that if one reserves the minimum memory necessary to make the OS happy, and anything else that may be running - then...

Don't let anyone here intimidate you. Sometimes they forget that they too had to start someplace. It was a good question, just a bit of a formatting issue maybe.

CB - You are correct, but the question generically asked what the "IN" is considered in a T-SQL statement. There were no examples or conditions qualifying the question.

Based upon that,...

This QOD actually has 2 answers that are correct, and should reflect such.

The "IN" statement can be used as both a predicate and an operator. See BOL:

Logical Operator

IN - TRUE...

We must remember that many people from many countries and cultures post here and we (Americans/English speaking majority) shouold not want to discourage anyone because of their grammer....

The question implies that there are 3 instances of SQL Server (ABC (Default), ABC\First and ABC\Second). With Replication set up between ABC and ABC\First, the removal of ABC\Second may not...

Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped by using DROP TABLE:

A local temporary table created in a stored procedure is dropped automatically...

You should post the table structure, index(es) as well as the select statement being issued. One can only speculate what the issues are without that information.

SJ - I believe that you are correct. SQL Server is not smart enough to tell you whether the value changed, but that there was an update that did not...

Great question - thought provoking. ALMOST got me to say trigger did not fire.

I would suggest that you determine the size/frequency needed to archive the errorlogs. If you are running C2 auditing, the logs grow very large very fast so you may need...

Brings back many fond memories, or nightmares back then. Excellent article, which has the opportunity to not only show alternatives to how we do things now, but also provides opportunities...

In an ideal, client server environment, you should from the local server execute a stored procedure on the remote server. This will put the workload on the remote server, utilizing...

Steve,

It has been my experience that in a system as you are describing that you would want to do a configuration where the .mdf file(s) are on a RAID 5...