Viewing 15 posts - 15,196 through 15,210 (of 22,219 total)
Gianluca Sartori (5/3/2010)
The only thing I'm sure of is database size, that changed from...
"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
May 3, 2010 at 7:38 am
ankur003 (5/3/2010)
"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
May 3, 2010 at 7:34 am
Greg Edwards-268690 (5/3/2010)
TRACEY-320982 (5/2/2010)
Thanks I will recommend upgrade to 2010 as soon as it out rather than in 5 years 🙂
I'd recommend taking a closer look at 2010 before recommending...
"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
May 3, 2010 at 7:30 am
Sounds like a permissions issue. That would be the main difference. But without details on exactly what error you're getting, it's hard to say beyond that.
"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
May 3, 2010 at 7:26 am
Total agreement. You'll get enough of what you need in order to build out your initial system with Express. If you hit limits, mostly likely in connections, you take 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
May 3, 2010 at 7:15 am
Since this is asking for opinion...
I think NOLOCK is probably the single most dangerous hint available. It's seductive and attractive and doesn't appear to cause a single problem. But 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
May 3, 2010 at 7:14 am
Here's an article just on how to handle errors within TSQL code:
http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench/%5B/url%5D
"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
May 3, 2010 at 7:07 am
The general approach is to identify what's running slow and then look at the execution plan to understand what it's doing. It's a rather large topic. Entire books have been...
"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
May 3, 2010 at 7:06 am
One other option, since there's no sample code and no execution plan, this is speculation. You showed the values passed as being strings '9-1-2009', etc. It's possible that the 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
May 3, 2010 at 7:04 am
Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of your ability...
"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
May 3, 2010 at 6:59 am
Just remember that you have to have FULL backups in place first in order to support log backups.
"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
May 3, 2010 at 6:52 am
Sqlfrenzy (5/3/2010)
Paul White NZ (5/3/2010)
Sqlfrenzy (4/29/2010)
"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
May 3, 2010 at 5:41 am
Paul White NZ (5/3/2010)
Bhuvnesh (4/30/2010)
HI i need better approach for the below one.i know this is very straight forward query but if somebody can help me here . greatly appreciated.
1....
"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
May 3, 2010 at 5:36 am
Gianluca Sartori (5/3/2010)
I would have put some more BREAK / CONTINUE in it and maybe nested another cursor,...
"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
May 3, 2010 at 5:30 am
Steve Jones - Editor (5/2/2010)
"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
May 3, 2010 at 5:28 am
Viewing 15 posts - 15,196 through 15,210 (of 22,219 total)