Viewing 15 posts - 12,286 through 12,300 (of 22,224 total)
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
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, but that session got...
"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 6:56 am
The thing is, you're running 2005 and 2000. They are two totally different optimizers. There were a number of upgrades in the engine as well as changes, stuff was fixed,...
"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 15, 2011 at 9:03 pm
WayneS (6/15/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 15, 2011 at 8:58 pm
ALZDBA (6/15/2011)
jcrawf02 (6/15/2011)
Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing,...
"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 15, 2011 at 1:37 pm
I've nominated a couple of people from this list and, as far as I know, nothing has come of it. I must write bad recommendation letters.
"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 15, 2011 at 12:05 pm
Cost is an estimate generated by the optimizer. You can't control except by making the plan simpler.
As to why the query would run faster because you removed quotes, I have...
"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 15, 2011 at 11:26 am
ALZDBA (6/15/2011)
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations, Grant.
Apparently you have been very active today, now you're already at :
Points: 10,881, Visits: 21,283
Nah, that's points. I was...
"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 15, 2011 at 7:06 am
GilaMonster (6/15/2011)
Grant Fritchey (6/15/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 15, 2011 at 7:04 am
You could create a hash column as a calculated column next to your varchar(max) and then put a unique constraint on the hash column. It's unlikely to be perfect, 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 15, 2011 at 5:58 am
That's 10,000 posts, done.
Wait, now it's 10,001.
"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 15, 2011 at 5:49 am
Viewing 15 posts - 12,286 through 12,300 (of 22,224 total)