Viewing 15 posts - 106 through 120 (of 960 total)
could you check the memory setting for the database server on which the reportserver databases are hosted , also check for any resource governor settings that might be restricting the...
October 21, 2015 at 1:24 am
A datasource is just a connection string so it shouldn't be this slow , how was the migration performed , detached the database and attached or redeployed all the code....
October 21, 2015 at 12:00 am
HTTP redirect is IIS should do the trick, have you tried it already ?
October 20, 2015 at 11:55 pm
with 100 million rows your better off using a Columnstore index or moving the table to SSAS. If the report requires data on a monthly basis partitioning it by month...
October 20, 2015 at 5:44 am
Your posting in the wrong forum i think , this is pure Vb.Net
https://msdn.microsoft.com/en-us/library/ms228598%28v=vs.90%29.aspx
the above link should work in creating a loop , you simply need to remove the...
October 20, 2015 at 5:39 am
It doesnt 🙂 i figured the random data is generated row by row and not from a set
October 20, 2015 at 5:25 am
in that case the link mentioned in the first reply should work , you simply need to pass the values into variable and use those variables within the child package.
October 20, 2015 at 5:07 am
I wasn't aware that a database could come online if a filegroup is empty, but if its online , shouldn't a backup followed by piecemeal restore work?
October 20, 2015 at 5:06 am
hmm DAC does have some limitations, I don't think this will help since its very difficult to maintain but I did implement this for a client recently.
A source database has...
October 20, 2015 at 5:01 am
Not sure your trying to achieve a piecemeal restore
It allows the DBA to restore readwrite filegroups that contain transactional data without having to go thru the overhead of restoring read...
October 20, 2015 at 4:47 am
select dateadd(s,-1*rand()*10000000 , getdate())
October 20, 2015 at 4:42 am
define configurations ? Are you referring to connection strings and file paths or different control flow logic?
October 20, 2015 at 4:37 am
Whats wrong with using Data Tier Applications ? you don't need CI ( although it would be good) or source control since the source and destination are compared directly...
October 20, 2015 at 4:35 am
Trust relationship between root domain and the sub domain should be enough. Could you provide more details
October 20, 2015 at 4:31 am
when storing the configurations in SQL Server you need to enter a configuration filter value as well, this filter value helps differentiate between configurations for one package vs others
October 20, 2015 at 4:29 am
Viewing 15 posts - 106 through 120 (of 960 total)