Viewing 15 posts - 19,381 through 19,395 (of 22,226 total)
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
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 12:25 pm
By the way, what's DBAccess?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 11:39 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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]
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 9:08 am
And is that a language term or a mathematic/engineering term?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 7:41 am
Funny, I was wondering the same thing. I even did a google search to try to track it down.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 7:00 am
Backups, absolutely.
And, this one does make people crazy, but I've been insisting on it for over a decade now... a tested script to deploy changes to production. No winging it,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2008 at 6:06 am
Viewing 15 posts - 19,381 through 19,395 (of 22,226 total)