Viewing 15 posts - 19,366 through 19,380 (of 22,219 total)
Best way to do that is to use the OUTPUT clause.
From BOL:
USE AdventureWorks;
GO
DECLARE @MyTableVar table( ScrapReasonID smallint,
...
"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 28, 2008 at 6:29 am
Totally different toolsets to a large degree. Actually I use both together. I do use SQL Compare & SQL Data Compare a little less than I used to, but I...
"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 28, 2008 at 6:27 am
The costs are just estimates. Proof in the differences between the two plans will be in the compile and execution times, and the amount of I/O.
Several things about the queries...
"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 28, 2008 at 5:45 am
You basically have it. TSQL isn't the best place to worry about formatting data. Convert is a pretty good method. But if you really need to break it down, take...
"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 28, 2008 at 5:34 am
george sibbald (10/27/2008)
People have a problem, they do a search, a post from this site pops up, and voila there...
"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 12:55 pm
Are you sure that it's not a view or a table valued function?
Is there an INSTEAD OF trigger on the table (if it is a table)?
"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 11:41 am
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,...
"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 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...
"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 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
"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
Viewing 15 posts - 19,366 through 19,380 (of 22,219 total)