Viewing 15 posts - 14,596 through 14,610 (of 22,227 total)
Things certainly got a little harsher than they should have and I guess I started it with my comment. Apologies. I meant it as a joke.
"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 22, 2010 at 12:28 pm
WayneS (7/22/2010)
Steve Jones - Editor (7/22/2010)
I do think this is a thorny issue. 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 22, 2010 at 12:22 pm
Just grouping by functional area isn't necessarilly going to help with I/O. Do you have multiple disks and multiple controllers? If not, just adding another file and filegroup isn't likely...
"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 22, 2010 at 12:19 pm
magasvs (7/22/2010)
I new I will get incorrect answer 🙂I based my answer on sys.indexes "type" column:
Type of index:
0 = Heap
1 = Clustered
2 = Nonclustered
3 = XML
4 = Spatial
I think this...
"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 22, 2010 at 11:24 am
GilaMonster (7/22/2010)
Jack Corbett (7/22/2010)
I got the answer right because of Grant's recent SQL University blog post[/url] which also lists 8 and references BOL.
I must admit, I don't agree with that....
"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 22, 2010 at 11:21 am
There is no implicit conversion from DATETIME to INT. If your table has no data, drop it and recreate it. Otherwise, what you need to do is create the new...
"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 22, 2010 at 6:55 am
Ooopsie. That's what I get for using my brain instead of the Mark I Eyeball. I really need a brain upgrade. Thanks.
"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 22, 2010 at 6:06 am
I'm in agreement here. You're possibly looking at a parameter sniffing issue, where the differering parameters are getting you differing execution plans. Based on what you describe, that's pretty likely....
"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 22, 2010 at 5:48 am
Something along these lines. You have a table with a column, CityName. One row has a value 'Hyderabad.' But that's a bad value. So someone is running a query that...
"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 22, 2010 at 5:45 am
Uhh... words fail me, but I'd be willing to discuss an hourly rate to untangle the mess.
I agree, based on what you're doing here, I would suggest switching the table...
"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 22, 2010 at 5:35 am
Also, you can search on the word "deprecated." That frequently indicates things that have been removed from SQL 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
July 22, 2010 at 5:32 am
Alterting and not much else... Check out Red Gate's SQL Alert. I think it might be exactly your cup of tea. I find it way too weak, but I want...
"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 21, 2010 at 8:11 pm
Jack Corbett (7/21/2010)
Agreed. He's got a persona that he keeps up online and when speaking.
I don't think even his presentation persona is nearly as ascerbic as his online persona....
"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 21, 2010 at 1:26 pm
rjohal-500813 (7/21/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 21, 2010 at 1:24 pm
Lynn Pettis (7/21/2010)
Steve Jones - Editor (7/16/2010)
...Not sure it will help, but that, along with a lovely complaint about Mr. Celko has made this a less than enjoyable day.
Never met...
"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 21, 2010 at 12:45 pm
Viewing 15 posts - 14,596 through 14,610 (of 22,227 total)