Hi,

I think it's impossible to guess the right size of your database.

Please post your table design, maybe someone can calculate the right size for 30 million rows.

What about index ore...

Hi,

I think, it "depends" on your database. What kind of application would you use?

If you have lots of IO, or a OLTP/OLAP, you need different drives with different speed.

The msdb,...

reported as SPAM

reported as SPAM

Hi,

for me as a human user, it would be OK to type a captcha to post something.

Or, only confirmed accounts can post something. I think, it should be possible to...

Hi,

right mouse click on the SQL Server Agent

=> Properties

=> History

Here you can change the value for the history of the jobs.

If you had jobs with many schedules, you need...

Hi,

I think it "depends" on you database. Have you checked the maintenance scripts from Ola Hallengren?

There is a stored procedure to rebuild/reorg you index, depending on the fragmentation-level and...

Hi,

I'm sorry, but I think, this is no SQL problem. Maybe you could get more help in this forum:

http://www.computing.net/forum/dos/1.html

Kind regards,

Andreas

Hi,

maybe this link could help you:

http://www.sqlservercentral.com/Forums/Topic1262785-1549-1.aspx

Kind regards,

Andreas

Hi,

I think, you had to create 50+ datasources to use them in the reports.

Or, are you able to store the result of the query in a table on the central...

Hi,

is it possible to start the SSMS with the credentials from the different domain on your local workstation?

"runas /netonly /user:differentDomain\USERNAME "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe""

Kind regards,

Andreas

Hi,

what about this tool:

http://www.hammerdb.com/

"HammerDB is an open source database load testing and benchmarking tool for Microsoft SQL Server"

Kind regards,

Andreas

Hi,

you can take a look to the scripts vom Ola Hallengren:

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

The index rebuild / reorg depends on the count of pages also.

Kind regards,

Andreas

Hi,

if you use Logshipping, the hole database is shipped. If you use Replication, you can choose, which object is replicated.

It depends on your requirement. Replication is just in time, but...

Hi,

google is your friend, sorry, but the first hit was the best answer:

If the principal server is lost, the mirror is suspended, but service can be forced to the mirror...