Viewing 15 posts - 20,326 through 20,340 (of 22,224 total)
Writing twice is writing twice. I've found the OUTPUT clause to be a bit more flexible in some ways than a trigger and it has the added value of being...
"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 27, 2008 at 7:02 am
Open the configuration manager. Click on "SQL Server 2005 Services" on the left side of the screen. You should see a list of services include "SQL Server" or "SQL Server...
"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 27, 2008 at 6:57 am
Have you run Profiler to watch the code come across? You can at least see what procedure calls are being made with what parameters and then test those same calls...
"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 27, 2008 at 6:42 am
Since 2008 hasn't been released yet, I wouldn't suggest making that migration now. But since it's supposed to be released in August (assuming they don't slip again), if you can...
"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 27, 2008 at 6:34 am
It is possible for the RI checks to be performance hit, sure. But if you've set up your tables & indexes appropriately, they shouldn't be. Doing an RI read on...
"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 27, 2008 at 6:29 am
It's my understanding that if you mark a database as read only, no locking occurs. So if you have a warehouse type of app where you won't be modifying 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 27, 2008 at 5:43 am
I'm not sure. I've never seen it go off without there being a collation value set either on the table or column or parameter. If you're getting collation errors on...
"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 23, 2008 at 1:24 pm
I'm not a hard-core programmer, so forgive me if I say something more stupid than I usually do...
You'll get the number of units that should be displayed and you'll get...
"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 23, 2008 at 12:26 pm
You can go into the Advanced Properties of a step and set up a number of retry attempts and a retry interval. That ought to do what you need.
"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 23, 2008 at 12:15 pm
Check the code to see if it added the COLLATE key word after the parameter definition. That would cause the problem.
"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 23, 2008 at 12:12 pm
fshguo (5/23/2008)
After I compared the execute...
"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 23, 2008 at 12:08 pm
Before I try to solve that, you might want to rethink the approach. If you fill out the rows for the user, even though there's no data, you either go...
"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 23, 2008 at 10:30 am
dp (5/23/2008)
"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 23, 2008 at 8:56 am
Oooh. Excellent. I've got a lot of respect for Aikido. Very useful techniques. We've had people teach seminars on it so that we at least have a level of understanding...
"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 23, 2008 at 6:56 am
I'd start with Itzik Ben-Gan's two books, Inside T-SQL Querying and Inside T-SQL Programming.
"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 23, 2008 at 6:51 am
Viewing 15 posts - 20,326 through 20,340 (of 22,224 total)