If you are posting answers to questions out on the forums (or, in my case, trying to), you have to be approaching it from a place of enlightened self-interest. Yes,...

Sure sounds like parameter sniffing. Since it's 2005, you might try using the OPTIMIZE FOR method to get good execution plans.

You might try setting these values into two other...

For a little help in posting a zip file and generating an execution plan:

http://www.jumpstarttv.com/uploading-an-execution-plan-to-sqlservercentralcom_385.aspx

Run a trace to capture the performance and use of the procedures. That will assist you in determining needed indexes, etc. It's especially important to do this when you're coming...

Access is Microsofts small scale relational data management tool. I wasn't sure what you meant by DBAccess. IBM DB2 has a program called DB-Access that is for querying databases.

Since we're...

I'd say keep the playing field level. A lot of posts doesn't translate into actual knowledge or special priveleges. I muck up at least as many times as I get...

I'm not sure if it matters or not, but when I downloaded the 2008 version of AdventureWorks, it installed on all the machines where I've installed it so far as...

And the query you're trying to write is an Access query, or you're using Access to connect to SQL Server and you're trying to write a SQL Server query?

The question is, what is it? This is a SQL Server forum. Is that a tool for...

By the way, what's DBAccess?

OK, you lost me. I can't tell what you're trying to do there.

You can't subtract one result set from another one and you have to have FROM clauses to...

Small tables, especially those that occupy less than one extent (that's 8 pages) generally won't defragment.

If I understand the question correctly, you're looking for the UNION operator. To combine the three statements:

SELECT...

FROM....

WHERE...

UNION

SELECT...

FROM..

WHERE...

UNION

SELECT...

FROM...

WHERE...

[/code]

And is that a language term or a mathematic/engineering term?

Actually, you can change the PK from nonclustered to clustered without dropping it. Here's an example:

CREATE TABLE t1

(c1 INT NOT NULL);

ALTER TABLE t1 ADD CONSTRAINT pk_t1 PRIMARY KEY NONCLUSTERED (c1);

CREATE...