Viewing 15 posts - 391 through 405 (of 1,065 total)
I have seen this very problem on an MSA1000... absolutely appaling I/O performance (huge queues, 1500ms per I/O) and a machine that just responded like something out of the stone...
October 2, 2009 at 8:42 am
dndaughtery (10/2/2009)
Someone was working on setting the cascading deletes but if that was the case wouldn't the junction tables be empty as well?
Yes...I was just about to edit my post...
October 2, 2009 at 6:55 am
A couple of possibilities
Do you use replication... and are the constraints marked as "NOT FOR REPLICATION"?
Are the foreign keys set up with CASCADE deletes?
October 2, 2009 at 6:48 am
Only way i can think of is to have single instance of sql server on each node. Can anyone give me some another better example?
Also what will happen if 2...
October 2, 2009 at 1:47 am
Marcin Gol [SQL Server MVP] (10/1/2009)
triggers are bad - because ... they are really hard to managed in big database
What makes them harder to manage in a large database, as...
October 2, 2009 at 1:38 am
repent_kog_is_near (10/1/2009)
If I make the two columns part of the primary key in tbl_person, will that help me to add the FK lookup?
Yes it will... but don't do it....
October 1, 2009 at 8:46 am
As your error message says, unless there is a Primary key or Unique constraint on the columns you want to reference in tbl_Person, you can't add the foreign key constraint.
You've...
October 1, 2009 at 7:43 am
info-1153976 (9/30/2009)
SELECT * FROM sys.sysprocesses gives the following important rows => see attached image (spid 54 is the script I'm running)
Spid 54 is the process that is executing xp_cmdshell, but...
September 30, 2009 at 1:52 pm
For the case where it never stops, can you see the process running in SQL Server (select * from sys.sysprocesses)?
If so, does it show as blocked... are the CPU...
September 30, 2009 at 7:34 am
If you set a large value for maxcmdsintran, and you have a network glitch, you have a potentially large number of commands to roll back and then resend.
You also...
September 30, 2009 at 3:42 am
1. Well the question is simple. How many triggers can be implemented in a single table.
Effectively unlimited, although you can only have 1 INSTEAD OF INSERT, 1 INSTEAD OF UPDATE...
September 30, 2009 at 3:32 am
Before making the decision, bear in mind that NULL does have a meaning.
As an example, if you have a Contact table, and as well as name and address, you want...
September 28, 2009 at 4:25 am
You've already asked this question here
http://www.sqlservercentral.com/Forums/Topic793661-338-1.aspx
and here
http://www.sqlservercentral.com/Forums/Topic793659-338-1.aspx
and had responses on both... what else are you looking for?
September 28, 2009 at 3:49 am
I don't have access to SQL Server at the moment to verify this, but you can can probably get what you are after from the backup_size column in the backupset...
September 25, 2009 at 10:52 am
This question has also been posted here http://www.sqlservercentral.com/Forums/Topic793659-338-1.aspx
September 25, 2009 at 8:55 am
Viewing 15 posts - 391 through 405 (of 1,065 total)