Viewing 15 posts - 19,366 through 19,380 (of 22,213 total)
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,...
October 27, 2008 at 8:17 am
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...
October 27, 2008 at 7:38 am
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
October 27, 2008 at 5:51 am
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...
October 27, 2008 at 5:48 am
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...
October 25, 2008 at 5:17 am
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...
October 25, 2008 at 3:34 am
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...
October 25, 2008 at 3:24 am
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?
October 25, 2008 at 3:21 am
Mangore75 (10/24/2008)
Grant Fritchey (10/24/2008)
By the way, what's DBAccess?Yes, DBAccess and I'm using one Table
The question is, what is it? This is a SQL Server forum. Is that a tool for...
October 24, 2008 at 12:25 pm
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...
October 24, 2008 at 11:38 am
Small tables, especially those that occupy less than one extent (that's 8 pages) generally won't defragment.
October 24, 2008 at 11:32 am
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]
October 24, 2008 at 9:08 am
And is that a language term or a mathematic/engineering term?
October 24, 2008 at 7:58 am
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...
October 24, 2008 at 7:41 am
Viewing 15 posts - 19,366 through 19,380 (of 22,213 total)