Great article Divya!

Cheers!

Interesting post!

But, I'm curious why would you use sp_helptext to get the content of stored procedure? Wouldn't it be easier if just right click on SP and ask SSMS...

Hi Olga,

Nice article and I really like the way you have used those excel files. Something new to play with for next couple of days. 😀

Cheers!

Hi Alen,

This tool essentially is meant for comparing publisher and subscriber tables (http://msdn.microsoft.com/en-us/library/ms162843.aspx). I've tried this tool to compare tables with about 25 million records on pretty standard server...

When I figured about this tool a while ago, I was same.. WOW.. And we just ended up using this tool at one of our DW implementation for change detection....

There's already so many article available to create CSV using SQL and IMO no...

I would rather build the CSV using SQL at first place

Check the transaction options of your package/container etc. Sounds like in your case, transaction is started and then went into lock or something.

for more details regarding transactions http://msdn.microsoft.com/en-us/library/ms137690.aspx

When I checked with my IT guy if we got backup of this database, guess what, he got backup of all databases except this and said I wasn't aware of...

As I read on some blog:

SQL Server 2008 = SQL 2005 with Big Service Pack :hehe:

Just bumped into very informative article on CDC, thought I should share here with everyone.

http://www.sql-server-performance.com/articles/dba/Capture_DML_Changes_Using_Change_Data_Capture_p1.aspx

Yes, this is absolutely possible but...

Assuming you are using SQL2K5 and you got this xml in variable called @xml of type xml, try this

SELECTcalls.cLog.value('OperatorsName[1]', 'varchar(512)') as OperatorsName

,calls.cLog.value('Date[1]', 'varchar(512)') as Date

,calls.cLog.value('Transcript[1]', 'varchar(512)') as Transcript

FROM@xml.nodes('//Call') as calls(cLog)

You...

@Chirag..I'm not sure what you mean by anything else!! This is just production DB server purely for database and no other application runs on this computer other than...

thanks for this tip Scott!!

I did exactly what you suggested in above thread, there's no single thread which goes to above 90% and stay there for long. most of them...