Viewing 15 posts - 19,006 through 19,020 (of 22,219 total)
In addition to the help file, you should consider picking up a copy of Itzik Ben-Gan's new book, T-SQL Fundamentals. It'll get you pretty far down the track pretty quickly.
"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 18, 2008 at 6:25 am
I was doing a bunch of research on this because it was making me crazy that I didn't know the answer. I finally posted, what I think is the answer,...
"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 18, 2008 at 6:23 am
I was just reading up on this again last night. According to the BOL, there is a queue and then the SMO or FileReader takes stuff from the queue. I...
"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 18, 2008 at 5:43 am
Are they sure Oracle provides enforced (key word) referential integrity on partial keys? I'll have to ask some of our local Oranuts.
"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 18, 2008 at 5:28 am
Oh you DBA's and your precision. It was more fun when it was kind of vague and mysterious.
"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 6:32 pm
maddogs (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 12:54 pm
The best way I can think of is to use the sqlcmd.exe. That allows you to format the output pretty much any way you want.
"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 12:35 pm
1) I think you're in it.
2) I'm pretty sure Steve makes them up as he goes along. You'll notice that 800 and 8000 both say Crazy Eights or something like...
"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 11:37 am
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
Viewing 15 posts - 19,006 through 19,020 (of 22,219 total)