Viewing 15 posts - 15,661 through 15,675 (of 22,219 total)
That's a pretty big topic for a web post. You might want to try tracking down a few books. Here's some information to get you started from MSDN.
"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
March 22, 2010 at 6:51 am
Maybe I misunderstood, but this sure looks to me like someone asking how to hack SQL Server. Am I way off?
"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
March 22, 2010 at 6:47 am
amandix (3/22/2010)
The goal is to use an attached copy of mssqlsystemresource db and alter some system stored procedures, 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
March 22, 2010 at 6:43 am
It's good that you can use the DMV to satisfy your need, but you should be able to see it in Performance Monitor too. It can be a common problem...
"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
March 22, 2010 at 6:34 am
Please don't cross-post. This just leads to confusion and bad information.
Do not reply.
Discussion already started here: http://www.sqlservercentral.com/Forums/Topic887267-373-1.aspx
"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
March 22, 2010 at 6:30 am
Without knowing more about the structure and what exactly is performing badly, it's going to be very hard to suggest solutions. Is the performance bad on inserts or on reads?...
"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
March 22, 2010 at 6:28 am
Steve Jones - Editor (3/22/2010)
I made it, a definitely journey from hell. Last year (2009), I had an only slightly...
"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
March 22, 2010 at 6:02 am
The Dixie Flatline (3/19/2010)
Grant, did you by any chance attend mighty Miskatonic University? Home of the Fightin' Shoggoths?
You betcha! I've got the sweatshirt at home. I used...
"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
March 19, 2010 at 7:54 am
Ray K (3/19/2010)
Don't forget us here in the Northeastern US -- we have Massachusetts!
And in Massachusetts: Lake Chargoggagoggmanchauggagoggchaubunagungamaugg
Just in case you ever wondered where Lovecraft came up with all...
"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
March 19, 2010 at 7:24 am
My vote is for holiday, a long one, something that involves imbibing beverages liberally sprinkled with alcohol.
"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
March 19, 2010 at 7:00 am
I've also been lucky to work for a company that is pretty good about training (although that's changing a bit). But the one thing I do, any time I can,...
"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
March 19, 2010 at 6:35 am
john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?
Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, 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
March 18, 2010 at 7:14 pm
You can put MVP in your signature all you want, but you can't link to this unless you have one.
Remember, MVP is about service to the community. Some, like Gail...
"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
March 18, 2010 at 11:14 am
Alvin Ramard (3/18/2010)
You wanna different language? Ok, mesa know one. 🙂
Down that path lies a world of pain.
"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
March 18, 2010 at 7:39 am
I'm pretty sure Tolkein's Elf language is published somewhere. That's sure to boil someone's blood.
"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
March 18, 2010 at 5:47 am
Viewing 15 posts - 15,661 through 15,675 (of 22,219 total)