It all depends what's required.

SSRS

PowerBI

Tableau

Qlik

All of these are data visualisation/reporting tools.

But it depends what's needed, just a simple dump of data, send mail is a crude way but hey...

so you are telling us that doing a

insert into archive_table
select *

from main_table where filtering_column = date_to_archive 

takes 5 minutes?

or that it takes that amount of time retrieving...

Thanks Paul for the wonderful script.

I have a requirement where the Primary and Secondary are in totally different domain. Now I am moving files through FTP. Can you help me...

Thanks Lindsay,

Can you help me understand the impact of the same in a cluster?

Thanks Mike.

Checked with Network team and they are not able to find anything.

From my investigation its pointing to database mail and service broker.  The error is thrown when the database...

• This reply was modified 5 years, 9 months ago by VastSQL.

The error is not very frequent now but happens at mid night .. Is there any probability that this can be a hacking??

(1) Not necessarily.  DBCC CHECKDB creates an internal snapshot of the database.  Database snapshots are sparse files, so they start off at (near) zero size and only grow when...

Recently been asked to look at why  ASQL instance will nto start.  this CLuster has not been built to best practice and is a 2 node cluster.  it has...

• This reply was modified 6 years ago by VastSQL.
• This reply was modified 6 years ago by VastSQL.

Rebooted old node and tried again after failover? I assume this is shared storage clustering, so the same master.mdf was scanned with dbcc?

If so, I'd fail back and try...

Msg 5901, Level 16, State 1, Line 1

One or more recovery units belonging to database 'master' failed to generate a checkpoint. This is typically caused by lack of...

The Instance is in a two node failover cluster and after failing over to second node DBCC completed without any error.

Checked those and didnt find any

Checked those and...

Did you get a chance to check the logs?(SQL Logs & Windows)

Tried in test environment and didnt find any issue in changing the file size. What is your model database file size?