Some Technical Details about MySpace.com Gathered from this Video

Technical Details about MySpace.com as on Nov 2006:

130 million users

50 million Unique Users

5 Billion Ads Per days

260 new users/day

3 billion total images

3...

Muthu,

There is a correction, IO error is not occuring before checkDB!...

Hi,

Kindly refer to this article for more details on this

http://www.sqlserverdba.co.cc/2009/02/advantage-disadvantage-or-pros-cons-or.html

Thanks! 🙂

you can download trial version of third party tools which will export SQL result set to Excel, CSV, PDF etc and give a try nisha

When Backup is happening to same volume (or drive) and same time if you have enabled autogrow option of 20% then SQL Server tries to increase the log file 2...

You can use DTCPing from Microsoft to troubleshoot MS-DTC Issues

Download link

Once downloaded, then follow this support article to troubleshoot issues.

Make sure that DTC is running with no issues. (Administrative...

Will triggers help the need?

Hi,

You need to explore your SSIS task. Is it connecting to internet to some webservice? Seems like .NET Issue.

EXEC msdb.dbo.sp_start_job @job_name = 'My SQL job'

This code will do!

Hi Andrews,

Thanks for your help. It works.

Hi Andrew,

This query you gave works fine. Could you please tell me how you got ASCII value of the output? I tried...

Yeah Marcus,

It is like this

Query Analyser -> SQL 2000 DB - It is not showing concatenated string in both Grid and Text

Query Analyser -> SQL 2005 DB...

Hi Marcus,

I tried that also marcus. For your reference, I'm attaching the output after running your query. Still no luck.

Also I noticed one thing...

Hi,

Anyway you are going to configure log shipping which is already a DR then why again Full backup to DR location?

...

I think there is a keyword called ROWCOUNT which can be set like

SET ROWCOUNT 5

which means you will get output after first 5 rows... You can use this keyword and...