Viewing 15 posts - 14,716 through 14,730 (of 22,227 total)
You're basically completely out of luck.
You might be able to query the cache to see which procedures might have a last run time near the time of the data loss...
"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
July 8, 2010 at 9:28 am
PowerShell! Microsoft is starting to set up a two-tier system of administrators and super-administrators. The differentiator is PowerShell. You want to be in that second group if you want long...
"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
July 8, 2010 at 8:59 am
The problem is, it's not a question of having a function that can do what you need. The issue is how is the data stored and retrieved and can you...
"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
July 8, 2010 at 8:50 am
Jim McLeod (7/8/2010)
"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
July 8, 2010 at 8:47 am
Looks like you're getting deadlocks due to the SELECT, EXEC, INSERT...SELECT process that both queries are running. Each one could put shared locks on identical rows in the initial select...
"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
July 8, 2010 at 8:43 am
Interesting discussion and not going the way I would have expected.
Since part of having a dev, qa, staging, prod environment seperation is testing the code and testing the deployment process,...
"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
July 8, 2010 at 8:31 am
One thing at a time. The query plans you posted were for a query without using the STIntersect command. I'm comparing apples to hammers with that. I'd need to see...
"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
July 8, 2010 at 6:25 am
Right, neither version of the query are using the spatial index. All you've got are table scans. First thing I'd try is using the derived table like I showed before....
"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
July 8, 2010 at 6:10 am
Jeff Moden (7/7/2010)
Tom.Thomson (7/7/2010)
bteraberry (7/7/2010)
The Dixie Flatline (7/7/2010)
You're not going to explain this in a such a way as to make him happy.I didn't believe you. Now I do.
I've...
"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
July 8, 2010 at 5:56 am
I'm completely missing the point of the questioner over here. Can someone else give them a hand maybe?
"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
July 7, 2010 at 1:21 pm
For a low-end system, not lots of server or lots of requirements for monitoring & alerting, you really can't go wrong with Red Gate SQL Alert. I do still think...
"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
July 7, 2010 at 12:36 pm
a.borgeld (7/7/2010)
"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
July 7, 2010 at 12:22 pm
Yep, that's the way I thought it worked too.
"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
July 7, 2010 at 12:13 pm
oliver.morris (7/7/2010)
I have a scalar function that works ok, it's just that its slow. I have indexed the geom column but it can take upto 40 mins to run on...
"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
July 7, 2010 at 12:05 pm
Pretty much, you can all this with SQL Server. SQL Agent can generate emails when jobs fail and you can generate emails when you get errors. The only trick would...
"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
July 7, 2010 at 11:56 am
Viewing 15 posts - 14,716 through 14,730 (of 22,227 total)