Viewing 15 posts - 12,271 through 12,285 (of 22,227 total)
Functions like that on your columns is going to lead to scans. Period. You can't get around it. I would not recommend that approach. As you add data to 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
June 20, 2011 at 6:47 am
You might want to make a case for upgrading to 2008. Then you can turn on optimize for ad hoc workload which will only store plan stubs for the first...
"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
June 20, 2011 at 5:45 am
I suspect some other processes are being run. Have you checked all scheduling to validate all the jobs that are run against the server? Have you checked to see if...
"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
June 20, 2011 at 5:40 am
Nope. If you're hitting the limit, you're hitting the limit. No way around it. You either have to dump data or you have to purchase a licensed copy of 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
June 20, 2011 at 5:38 am
iancadwallader (6/20/2011)
Thanks for this, and yes I agree its not the best way to be doing things.
The idea really behind it is that the helpdesk system being incorporated could...
"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
June 20, 2011 at 5:22 am
Jeff, I'd never admonish you... much.
However, in this case, I agree, but only to a point. JOIN order does matter, and your choice of JOIN order, especially on more complex...
"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
June 18, 2011 at 11:13 am
blake colson-405790 (6/17/2011)
"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
June 18, 2011 at 10:51 am
WayneS (6/15/2011)
My questions:
1. Can you build...
"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
June 17, 2011 at 9:21 am
george sibbald (6/17/2011)
Grant Fritchey (6/17/2011)
george sibbald (6/17/2011)
Gus, SA in dev, really? Should that ever be...
"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
June 17, 2011 at 8:49 am
george sibbald (6/17/2011)
Gus, SA in dev, really? Should that ever be a necessity?
any more 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
June 17, 2011 at 7:32 am
george sibbald (6/17/2011)
quick straw poll if you don't mind guys -how much access should developers have in a development environment?
Sandbox - Everything, sa
Shared Environment - generally ddl_admin, security_admin, data_reader, data_writer...
"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
June 17, 2011 at 6:53 am
End time you're only going to get by inference. If you check for the lock regularly and it's gone, that's when it ended.
Start time on a lock is pretty easy...
"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
June 17, 2011 at 6:46 am
There's blocking or resource contention or something. I'd start working off of wait states. If you can see the processes as they're running, what are they waiting on? If 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
June 17, 2011 at 3:53 am
Nope. Identity is a number field. It would need to go into a number data type such as int or bigint. What you could do is create a calculated field...
"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
June 17, 2011 at 3:48 am
Not seeing the query or the execution plan, I have no idea.
As a guess, I'll go back to what I said before, you're getting timeouts on the optimization process and...
"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
June 17, 2011 at 3:22 am
Viewing 15 posts - 12,271 through 12,285 (of 22,227 total)