Viewing 15 posts - 18,721 through 18,735 (of 22,219 total)
You know, I don't think it really matters. Each has strengths and each has weaknesses. By and large, I prefer SQL Server and that's where I make my money, 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
January 15, 2009 at 6:36 am
jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?(laughs nervously, backs away slowly...)
Oh now, don't be getting nervous...
"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
January 15, 2009 at 6:29 am
We went through a pretty bad experience with virtual servers in development (you can read about my adventures here on SQL Server Central). This week though I was up at...
"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
January 15, 2009 at 5:46 am
Jeff Moden (1/14/2009)
Chris Morris (1/14/2009)
Jeff Moden (1/13/2009)
Steve Jones - Editor (1/13/2009)
And here I was thinking pork chops were pork chops, not developers' heads.
Oooohhhh.... I might be in trouble... I've 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
January 15, 2009 at 5:40 am
It sounds like you have some slow performing queries. Can you post the execution plans?
Is there some sort of trigger or something becuase, if I'm reading the queries correctly, one...
"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
January 14, 2009 at 5:51 pm
Can you post the execution plans?
It does sound like you need a covering index. A key lookup can be very expensive.
"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
January 14, 2009 at 5:46 pm
Hey Gail,
I see you suggested turning the safeties off to my bestest friend. Holy cow! Triggers calling unsafe CLR code. That ought to be entertaining. Some consultant somewhere is going...
"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
January 14, 2009 at 1:19 pm
Amol.Naik (1/14/2009)
The Primary Key clustered index is infact defined on the TokenNo VARCHAR(25). Tokens used to be 25-digit codes earlier, but now they are 12 digit. These are guaranteed to...
"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
January 14, 2009 at 1:08 pm
bdgenterprises (1/14/2009)
Thank you very much. I couldn't see the forest from the trees. That was supposed to be 510, not 10.
Thank you very much!...
"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
January 14, 2009 at 1:03 pm
I guess I'm lucky. I've only had it lock up the system once. You guys ought to post your experiences over at the Red Gate forums. They'd be interested to...
"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
January 14, 2009 at 1:02 pm
I agree. SQL Prompt works better in lots of ways. That's before we talk about formatting your code for you... Woo Hoo!
"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
January 14, 2009 at 12:20 pm
You can manage 2005 servers from the 2008 interface (and 2000 servers, not 7.0 or 6.5).
Intellisense will only work on 2008 instances. Sorry.
Check out Red Gate's SQL Prompt. I...
"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
January 14, 2009 at 11:35 am
Hey, AdventureWorks is my friend. Without it I'd have to create a fake database as well as fake queries for the book.
There's cool stuff on Codeplex. Nose around a bit.
"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
January 14, 2009 at 11:32 am
All the good Microsoft examples are up there. This might be it.
"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
January 14, 2009 at 10:19 am
Steve Jones - Editor (1/14/2009)
I think you did alright, Grant. Typical response for people that don't want to think about issues, just solve what they think is the problem.
Thanks Steve,...
"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
January 14, 2009 at 10:16 am
Viewing 15 posts - 18,721 through 18,735 (of 22,219 total)