Viewing 15 posts - 21,841 through 21,855 (of 22,219 total)
In addition to all those recommendations, I'd suggest taking the IN clause and turning that into a join, even if you keep it as a derived table. In terms of...
"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
May 17, 2007 at 6:47 am
HI STELLA!
<big hug>
"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
May 17, 2007 at 5:28 am
Most of our procs are converted to XML out on the client (app server actually). No real need to output to XML, in most cases, in the procedure. From your...
"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
May 17, 2007 at 5:26 am
Oh hell, time to start a support group. Who needs a hug?
Hi, my name is Grant. I'm unable to upload useless little pictures.
<CROWD> Hi Grant
"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
May 17, 2007 at 4:47 am
Code reuse in this circumstance sounds really useful. I think I might take a look around. I'm sure we have something along these lines that might, possibly benefit.
I'm curious to see the...
"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
May 17, 2007 at 4:23 am
What about:
UPDATE
[Northwind].[dbo].[Orders]
SET [ShippedDate] = x.myshipdate
FROM ( "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2007 at 8:10 am
What error are you getting? You can run a backup command from just about anywhere (a linked server isn't really necessary), but the real issue is usually one of disk...
"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
May 16, 2007 at 8:05 am
Assuming a clustered index on the UniqueRowId (or a combination of the other columns used in the aggregate query), in a similar situation we've found that using TOP(1) with an...
"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
May 16, 2007 at 7:58 am
You can store all those columns, but the question is, why would you need to? For example, I've done exactly what you're laying out because we found that all our...
"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
May 16, 2007 at 7:18 am
Some of that information is available from sys.syslogins. I think the more dynamic stuff, like the number of logons, isn't going to be there. You may need to set up...
"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
May 16, 2007 at 7:10 am
Pig Pile!
Seriously though, everyone got it right. Replication has the type of behavior you're looking for. It won't seriously impact your performance (configured correctly) and it's a lot more fault...
"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
May 16, 2007 at 6:57 am
Very interesting stuff. Thanks for sharing. I'd love to know if you do find any kind of memory leak since, from a performance stand point you already proved that 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
May 15, 2007 at 6:32 am
Yeah, I've read a lot of that stuff. I was just wondering if anyone had come up with a compelling, real-world, example of using CLR and getting more or better...
"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
May 14, 2007 at 3:42 am
Can you post the query plan as XML? It sounds like you might be missing an index which is why you're getting the work table in tempdb. Possibly in the...
"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
May 11, 2007 at 7:12 am
I'm not entirely sure what you mean, but I think you you're looking for something along the lines the OPENROWSET command. Look it up in Books Online.
"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
May 10, 2007 at 11:01 am
Viewing 15 posts - 21,841 through 21,855 (of 22,219 total)