have you tried this and gotten an error? i tried something like this a few weeks ago and it wouldn't let me use parameters like that. Forgot the name MS...

hardware resources. we run a scale out version of SSRS and the main server has 32GB of RAM. Reason is our BI devs wrote a bad query one time and...

have you tried to run the report while RDP'd on the Report Server? there is a setting in SSRS to forward the error to the host but i forgot where...

we have archive databases where we put the data before deleting it

First archive the data

attempt delete

delete data in other tables if there are FK issues

delete data

on some tables we also...

where i work we have 2 DBA's to manage the servers, a few dozen developers and a few BI developers who write most of the SSRS reports and BI processes

rewrote it to use Unions during the day and changed it on SSRS to use Report Parameters. I was hoping to email the data once a day as an alert...

interesting, i tried to run the code below and i'm still getting all the extra data

with repl_latency_cte

as

(

select a.counterid, substring(a.machinename,3,20) as machinename, a.objectname, a.countername, a.instancename, convert(int, b.countervalue) as CounterValue, max(convert(datetime, substring(b.counterdatetime,1,...

if you want internet backups then look into some of the cloud solutions from i365 or others

the data is the ODBC tables that perfmon creates when you set it to log to a database rather than a file

thx, going to play with some of the advice...

we have data going back over 10 years. in the 700GB database that had the long recovery time we told our BI people and they split it into 2 databases....

our 2TB databases have tables with over a billion rows that recover faster than the 700GB database we ended up splitting up where the tables were only a fraction of...

we have databases from a few MB to almost 2TB. we had a problem with a database in the 700GB range that would take 2 hours to recover. we ended...

we put up a stand along SQL server just to hold the drivers for other database servers and to pass the data to our MSSQL servers that actually hold the...

the SSIS would be running from a SQL server on our domain, the SQL servers with the data are in workgroup mode and not on any domain. the database is...

used your method

i set up a VMWare instance with SQL on it and manually copied the files over.

created a db with the same name

shut down sql and renamed the...