Hello David,

First thing suggested is to keep both your DB Server to same Service Pack. Your source is SP1 and Destination is SP2.

Second, Your Servers have different Editions. So please...

Hi Gail,

I was also stuck in similar scenario, and my database went into DBName(Recovery) for a short time and then in backgorund it took 16 hour for the rollback part...

As you are assigned the new task of DBA.

The first thing I would suggest you to document all the Servers/Databases in your environment. Little bit lenghty and boring but...

Thanks Gail,

I did the same.

I got below error Before I ran Repair on my DB,when I tried to take DB ONLINE :-

The log scan number (8615:729:38) passed to log scan in database 'DBName' is...

I got below error when I tried to take DB ONLINE :-

The log scan number (8615:729:38) passed to log scan in database 'DBName' is not valid. This error may indicate...

Thanks Gail,

Because CheckDB didn't give any log error. Does this mean that CHECKDB never look for log file in its operation.

Try using Delete with Joining TableA and TableB with the 5 columns you have to check for match.

Please consider you condition for matching with OR and AND, whether all the...

Hi,

Please post the table script and sample data so that we can further understand your problem.

Hi,

You can go through the below link and do some research how to configure it.

http://msdn.microsoft.com/en-us/library/ms151799.aspx

Thanks

Select distinct CoveNoteNo,ProposerName,

convert(decimal(18,2),FinalPremium) as finalpremium,

p.ProductName as Product,ChqNo,ChqDate

from DtlCvrNotePremium d with(nolock)

inner join usrmgmt..usgi_product p with(nolock) on d.product=p.productvalue

Where d.ChqNo is null and d.category='MO'

You can add a ISNULL filter and have...

Of Course the trace will stop, Since you are running SQL Profiler from machine A.

Thanks a lot for your views. I really appreciate your involvement with the topic.

Hi Jim,

I got exactly the same results you have posted with clustered index....

Dear Experts, I want to know why perfmon is showing page split while I am inserting incremental values for Clustered Index

Thanks in advance.

Thanks Jeff, Here is the script I am running and using perfmon I am measuring page splits/sec.

CREATE TABLE [dbo].[Tab1](

[ORG_KEY] [bigint],

[PROD_KEY] [bigint],

[TIME_KEY] [bigint],

[CST_NON] [float],

[CST_RPL] [float],

[RTL_NON] [float],

[RTL_RPL] [float],

[UNT_NON] [float],

[UNT_RPL] [float],

[UPDATE_DATE] [datetime]

)

with...