Viewing 15 posts - 12,256 through 12,270 (of 22,224 total)
It's less than 1gb? Why not look into using SQL Azure? Sounds like a perfect solution.
"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:59 am
But, the key point here is, that you can't use nolock with a delete. A delete operation absolutely must lock as it deletes, no options. If you issue a nolock...
"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:58 am
If there is no blocking occurring, then your hardware is extremely slow, or there is a problem with your code.
As was already stated, there's not enough information here to provide...
"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:55 am
Microsoft books online shows exactly how to configure your system for performing stand alone installs through the command line. You can then do this from a batch file or, better...
"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:53 am
Lynn Pettis (6/21/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 21, 2011 at 4:06 am
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
Viewing 15 posts - 12,256 through 12,270 (of 22,224 total)