Viewing 15 posts - 12,271 through 12,285 (of 22,224 total)
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
First thing was the integration with my Droid phone. It was seemless. Once I had logged into Google, all my data was moved across to the Asus, like magic. Second,...
"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 16, 2011 at 5:04 pm
GilaMonster (6/16/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 16, 2011 at 8:24 am
Roy Ernest (6/16/2011)
Grant Fritchey (6/16/2011)
Roy Ernest (6/16/2011)
Grant submitted a session on how to write good abstracts. 🙂 Maybe we can ask him to write an article up on it. 🙂
Yeah,...
"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 16, 2011 at 7:43 am
Viewing 15 posts - 12,271 through 12,285 (of 22,224 total)