see this http://www.johnsansom.com/the-database-administrators-primary-responsibility/

have you checkedt he statuses of morrored databases ? are they showing ("mirrored synchrnoized restoring...") ?

post the expected output based on your above data's example

Can you elaborate this ?

Thanks for this LATEST reply but this is 2 years old thread 😀

First of all, in my 4 years of log relationship with SSC, i havent seen any newbie writing such a long post :-D.it clearly showing that you know that what...

Have you used this ?

Please provide expected output too here with respect to the any effective date (from you sample data)

Another thing,

send a test mail to investigate the point of failure.

Right click database mail –View database mail log to see error or we can SELECT * FROM msdb.dbo.sysmail_event_log...

I recommend that you use Database Mail Configuration Wizard, the Database Mail Configuration Wizard provides a convenient way to manage Database Mail configuration objects and enables Database Mail.

For more...

this can put more light here

CREATE LOGIN login1 WITH PASSWORD = 'J345#$)thb';

CREATE LOGIN login2 WITH PASSWORD = 'Uor80$23b';

GO

CREATE USER user1 FOR LOGIN login1;

CREATE USER user2 FOR LOGIN login2;

GO

begin tran...

select 'ALTER DATABASE ' + Name + ' SET AUTO_UPDATE_STATISTICS OFF ' from sys.databases where database_id > 4

Copy the result of above query in run window and...

In simple words.

Key/RID lookup means Non-clustered index is not covering all the participated columns in one query for one particular table. so optimizer choose the heap(RID) or clustered index(Key) for...

winmansoft (3/5/2013)

---

Bhuvnesh (3/5/2013)

---

winmansoft (3/5/2013)

---

I have searching for a query that returns a row if column value contains result of another query. Its like "select * from table1 where col...

winmansoft (3/5/2013)

---

I have searching for a query that returns a row if column value contains result of another query. Its like "select * from table1 where col contains(select col1...