Viewing 15 posts - 12,271 through 12,285 (of 22,219 total)
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
ESAT ERKEC (6/16/2011)
But i want to ask one think what about cpu and read options Cpu can be used separate files?
Well, yes, CPU is used to determine what goes where,...
"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:15 am
You're going to have to rewrite everything.
Sorry.
The thing is, if you try using linked servers, what happens is, let's say you join two tables across databases, in a single server,...
"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:11 am
The suggestions already posted for a heartbeat monitor are fine. But if you really want to tell the operator "what is wrong" other than the server is there or not...
"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:06 am
I've started using an Android tablet, the Asus Transformer, instead of the iPad. I'm much happier with it as a production device as well as a consumption device.
That said,...
"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:03 am
Multiple files, but a single drive? I'm not surprised that performance is better with a single file. You're asking SQL Server to do extra work to distribute the data, but...
"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:01 am
Viewing 15 posts - 12,271 through 12,285 (of 22,219 total)