Viewing 15 posts - 41,686 through 41,700 (of 49,562 total)
CrazyMan (1/16/2009)
Alter tableAlter table Table Name Drop Constraint ConstraintName
True, if the clustered index is part of a primary key or unique constraint. If it's just...
January 16, 2009 at 5:23 am
Adi Cohn (1/16/2009)
Actually when you have legal weapons there are procedures in air lines that lets you fly with your weapons.
I think it depends on the airline and...
January 16, 2009 at 5:16 am
Suresh Kumar Maganti (6/11/2008)
January 16, 2009 at 1:07 am
What's a .bbk file? It's not the standard extention for a SQL backup (though that doesn't mean it isn't a sQL backup)
Where did you get the file? How was it...
January 16, 2009 at 1:04 am
Lynn Pettis (1/15/2009)
January 16, 2009 at 1:00 am
Well, running them would be a far quicker way of seeing which is faster than asking.
I can say that the third will probably be the slowest. Don't know about...
January 16, 2009 at 12:58 am
Sandra Skaar (1/15/2009)
January 16, 2009 at 12:53 am
Marker (1/15/2009)
GilaMonster: it does not backup up the TRN log during the index rebuild.
As in it runs for the duration of the index rebuild (and if that's the...
January 16, 2009 at 12:32 am
Paresh Prajapati (1/15/2009)
Create DDL trigger to change track and send mail notification.
Um...
DDL triggers fire when there's a change to the table structure, not the table's data (which is what foxjazz...
January 16, 2009 at 12:31 am
george (1/15/2009)
I've simply posted in the wrong forum.
No prob.
All of these forums here are dedicated to SQL server. We have no .net forums. I'd recommend you a good .net...
January 16, 2009 at 12:27 am
george (1/15/2009)
Would like to fully justify a section of text.At present I just have a simple text box like so . . .
Forgive me for my confusion, but what does...
January 15, 2009 at 12:32 pm
Marker (1/15/2009)
I noticed that the 15min TRN backup starts 15min before the index rebuild but does not backup the TRN log during the index rebuild.
Doesn't back it...
January 15, 2009 at 12:25 pm
RBarryYoung (1/15/2009)
You might have more luck looking for Kendo instructors. There's a whole Kendo Federation in SA, so I would think that there were a few instructors.
There's a school...
January 15, 2009 at 12:22 pm
-- normal query
select o.name, c.name
FROM sys.objects o
inner join sys.columns c on o.object_id = c.object_id
-- noncorrelated subquery with inner join
select o.name, c.name...
January 15, 2009 at 11:57 am
leonp (1/15/2009)
ok gila now that confuses me
What confuses you? There's no other way to correlate a subquery in the from clause than to use one of the APPLY operators....
January 15, 2009 at 11:47 am
Viewing 15 posts - 41,686 through 41,700 (of 49,562 total)