Viewing 15 posts - 18,871 through 18,885 (of 22,226 total)
GilaMonster (1/6/2009)
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
I have 4, 6, 8, 10...
"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 6, 2009 at 8:12 am
Jeff Moden (1/6/2009)
Grant Fritchey (1/5/2009)
RBarryYoung (1/5/2009)
Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.
WITH...
"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 6, 2009 at 6:30 am
URGENT!
How do you pick indexes... Oh lordy
http://www.sqlservercentral.com/Forums/Topic630357-360-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
January 6, 2009 at 6:23 am
I didn't see anyone mention it, but if you're moving scheduled Agent jobs, just script them out on the first server and you can run them on the second. Edit...
"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 6, 2009 at 6:22 am
nairsanthu1977 (1/6/2009)
Can anyone give me some tips on creating indexes in sql server 2005. when to created index on single/multiple columsn etc...
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 6, 2009 at 6:19 am
There are some stress tools out there for when you get past the basics of query performance troubleshooting. Quest offers one called Benchmark Factory. Idera used to have one, 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 6, 2009 at 6:12 am
nitinpatel31 (1/6/2009)
Any way here is the...
"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 6, 2009 at 6:05 am
My rule of thumb is the same as Jeff's with one exception.
I've found some queries that are only, ever, doing a full scan of the temp table can run faster...
"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 6, 2009 at 5:48 am
If you think these queries are bad, you should see the stuff coming out of nHibernate. I've only seen a few so far, but they're pretty horrifying. It does implicit...
"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 5, 2009 at 6:25 pm
I expected it to perform the join inside a sub-select and then select from the result set as a single set of values. That would have helped explain why 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 5, 2009 at 11:55 am
I'm not sure, I haven't worked with Entity Framework much. What does it do when it has to do a JOIN between two tables?
"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 5, 2009 at 11:33 am
I'll bet the execution plan for both is the same.
It's a messy way to write procedures, at least for really simple things like this, but it's not going to add...
"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 5, 2009 at 11:00 am
Michael Earl (1/5/2009)
Eric Klovning posted a great response in this thread:http://www.sqlservercentral.com/Forums/Topic629445-145-1.aspx
It was a link to:
http://letmegooglethatforyou.com/?q=free+open+source+sql+schema+diff+tool
That gave me a really good laugh first thing this morning. I think that's a pretty...
"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 5, 2009 at 10:55 am
Ah, I didn't go back and look at the execution plan again.
"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 5, 2009 at 10:52 am
Hey Jack,
Yeah, OPTIMIZE FOR is actually more than a little big dangerous. What happens when the underlying statistics change? You have to constantly review the work you did with it.
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 5, 2009 at 8:57 am
Viewing 15 posts - 18,871 through 18,885 (of 22,226 total)