Viewing 15 posts - 1 through 15 (of 15 total)
Oh dear. Oh dear dear. Such an idiot I am.
There are several thousand(!) FOREIGN KEYS to this table from several thousand other tables. With cascade delete.
The server tries to delete...
February 24, 2013 at 5:43 am
Today I know MUCH more.
The problem arises when Replication agents start from their schedules. It never arises if I start the same agents from the Replication Monitor or 'View synchronization...
February 19, 2013 at 11:39 pm
RTaylor2208 (2/19/2013)
Is there any errors reported in the SQL Server Error log within management in SSMS
No.
or any errors written to the windows event logs?
No. Or I do not see any.
February 19, 2013 at 5:02 am
KTD (2/11/2013)... replicating a large DB of this size.
Not of this size. 15 times smaller... but this looks like irrelevant. The using of snapshot was out of question from the...
February 12, 2013 at 2:18 am
anthony.green (2/12/2013)
Back it up, send it to ServerG for ServerB to see, then do regular transaction log backups...
February 12, 2013 at 1:56 am
Subbu's (1/11/2013)
What is scalability of a database.
For the first approximation "scalability" is an ability to scale ;).
It means the ability to deal with increased workload just by adding more hardware...
January 11, 2013 at 3:07 am
Dave Ballantyne (12/29/2012)
In a phone directory the clustered index is LastName,FirstName, Street Address.
That being the case how can the be a clustered...
December 29, 2012 at 11:07 am
GilaMonster (12/29/2012)
Because the table only exists once.
Gail, this is just the question. I know how the things are - I do not understand why. The table only exists once...
December 29, 2012 at 10:59 am
Lokesh Vij (12/21/2012)
I do not agree with this. COUNT(*) only considers counting the number of rows. It does not even bother to take a look at the columns and there...
December 21, 2012 at 5:02 am
There is just one variant of one aggregate function that DOES take nulls into account: COUNT(*).
However, it is uncompatible with DISTINCT clause.
SELECT COUNT(col1) as cnt_col1
,...
December 21, 2012 at 2:18 am
SQLRNNR (12/20/2012)
I don't disagree with the correct answer. I disagree with the explanation. I also do disagree with many of the complaints thus far about the question. ...
December 20, 2012 at 2:13 am
Jeff Moden (12/19/2012)
One is that it's SQL Server proprietary and will not port to most other RDBMS engines.
Another reason is that it will allow you to make mistakes (just like...
December 19, 2012 at 11:21 pm
Lokesh Vij (12/19/2012) Ideally, both Unique constraint and Unique index are same as Unique Constraint creates Unique Index to maintain the constraint to prevent duplicate keys.
They are definitely not. Every...
December 19, 2012 at 9:29 pm
Do not like the question.
First of all, it IS definitely possible to create a table which would accept any number of NULLs but no duplicate non-null values in 2005 and...
December 19, 2012 at 9:24 pm
- Used UPDATE...FROM more than once
I definitely do not have the slightest resembalnce to "SQL Expert", but this phrase punched me hard.
I have no idea why using UPDATE...FROM is bad....
December 19, 2012 at 8:22 pm
Viewing 15 posts - 1 through 15 (of 15 total)