Viewing 15 posts - 19,021 through 19,035 (of 22,226 total)
Well, actually, I prefer C#, but I also think that there's a critical mass behind it now that wasn't there until the last year or two. But now, yeah, that's...
"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
December 17, 2008 at 10:49 am
Matt Miller (12/17/2008)
Grant Fritchey (12/17/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
December 17, 2008 at 10:42 am
It's in keeping with what I'm seeing. Our company has started switching over to C#. The newest project starting development is going with C# (and nHibernate, but that's a different...
"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
December 17, 2008 at 10:16 am
Try changing the exeucte to
EXEC sp_executesql @backupString
and using an NVARCHAR on the backupstring. I tested your code several times that way. It worked finel.
"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
December 17, 2008 at 9:52 am
Jack Corbett (12/17/2008)
GilaMonster (12/17/2008)
Grant Fritchey (12/17/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
December 17, 2008 at 9:03 am
Jonathan Kehayias (12/17/2008)
Grant Fritchey (12/17/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
December 17, 2008 at 8:58 am
Jeff Moden (12/17/2008)
GilaMonster (12/17/2008)
r.hensbergen (12/17/2008)
Do posters think we're answering bots instead of real people?
I suspect that some do, or think that we work for SSC. I recall someone apologising...
"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
December 17, 2008 at 8:51 am
For the very little it's worth, that's pretty much in line with my understanding of the process.
The only point I'm not sure about is the buffer when you're using...
"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
December 17, 2008 at 8:39 am
Ha! At this point I don't see a need for it for anything except resume padding.
I don't have a good resource for it yet. I've been floundering my way through...
"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
December 17, 2008 at 8:35 am
Can you generate and post a couple of execution plans? That will help show what's happening under the covers on your system, with your data.
This will help if you haven't...
"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
December 17, 2008 at 8:27 am
Personally, C#. It's what all the cool kids seem to be doing these days, so it's more likely to allow you get jobs and/or recruit people into the jobs 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
December 17, 2008 at 8:23 am
Fraggle (12/17/2008)
Gail, are there any articles you would recommend on using server side traces?
Grant, you are correct. I did fail to mention...
"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
December 17, 2008 at 7:33 am
Google & BOL aside, they've managed to find their way to this site, navigate to the forums, type their question.... Didn't even a one of them look up & to...
"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
December 17, 2008 at 7:26 am
Yeah, Ian, that sounds like a good approach. I was thinking more or less the same thing, but didn't put in as clear as manner as you just did.
"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
December 17, 2008 at 7:14 am
OK. Now that I'm seeing the full graph at last, I'll sound a little less foolish (but only a little). I'm seeing you running two updates, in different orders, 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
December 17, 2008 at 7:12 am
Viewing 15 posts - 19,021 through 19,035 (of 22,226 total)