Viewing 15 posts - 12,256 through 12,270 (of 22,219 total)
Syed Jahanzaib Bin hassan (6/20/2011)
1) Does all the features that were provided by Sql server 2000 will be suppported by Sql Serve 2008?
Full support of legacy applications
I'd be very careful...
"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 21, 2011 at 4:04 am
Jayanth_Kurup (6/20/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 20, 2011 at 4:20 pm
I don't know. It's something I'd have to test. You need to let us know what a "large number" looks like to you.
"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 20, 2011 at 8:54 am
Are you asking if output parameters are slow? No, they're not. If anything, they can be faster than returning a result set.
Are you asking if large numbers of output...
"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 20, 2011 at 8:40 am
Brandie Tarvin (6/20/2011)
polasabhushan (6/20/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 20, 2011 at 7:03 am
polasabhushan (6/20/2011)
I have not found anything on errorlog , probably not sure where to look and what to look....
"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 20, 2011 at 7:00 am
Agile development, when done correctly, is one of the most disciplined approaches to development I've ever seen. Yes, designing the database without complete requirements can be difficult, but in general,...
"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 20, 2011 at 6:52 am
Functions like that on your columns is going to lead to scans. Period. You can't get around it. I would not recommend that approach. As you add data to 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
June 20, 2011 at 6:47 am
You might want to make a case for upgrading to 2008. Then you can turn on optimize for ad hoc workload which will only store plan stubs for the first...
"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 20, 2011 at 5:45 am
I suspect some other processes are being run. Have you checked all scheduling to validate all the jobs that are run against the server? Have you checked to see if...
"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 20, 2011 at 5:40 am
Nope. If you're hitting the limit, you're hitting the limit. No way around it. You either have to dump data or you have to purchase a licensed copy of 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
June 20, 2011 at 5:38 am
iancadwallader (6/20/2011)
Thanks for this, and yes I agree its not the best way to be doing things.
The idea really behind it is that the helpdesk system being incorporated 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
June 20, 2011 at 5:22 am
Jeff, I'd never admonish you... much.
However, in this case, I agree, but only to a point. JOIN order does matter, and your choice of JOIN order, especially on more complex...
"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 18, 2011 at 11:13 am
blake colson-405790 (6/17/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 18, 2011 at 10:51 am
WayneS (6/15/2011)
My questions:
1. Can you build...
"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 17, 2011 at 9:21 am
Viewing 15 posts - 12,256 through 12,270 (of 22,219 total)