TechSoup is a pretty cool nonprofit that offers services and partners with technology companies to offer free or discounted software, hardware as well as cloud services. There are Azure credits...

Did you also rename the physical file on disk? Alter database...Modify file won't rename the file on disk.

Sue

No one can tell you what the ideal would be - it really depends on your environment, your data warehouse, etc.

The files seem pretty small with a small growth increment....

To start, you would probably want to check the full text log. That would list the last crawl and any errors that may have occurred. You would also want to...

You can use the objectproperty function to see if a view (or table) is indexed - along the lines of:

SELECT * 
FROM sys.objects
WHERE type='V'
and OBJECTPROPERTY(object_id,'IsIndexed')=1

Sue

No, not using the same stored procedure. If you do a search, you will find...

I'm not that well versed at Powershell but it's my understanding that it's mostly because in Powershell it's returning objects so it's not like just running a few sqlcmd statements....

Not really sure what doesn't work on the second link means - the link works so I would guess you mean it doesn't apply. On the first link, there is...

Nothing the same but it also...

Invoke-SQLCmd can have issues with multiple results and you end up with just the one. There are a few different ways to work around it with Invoke-SQLCmd. One of the...

There are a lot of articles available on this site and web posts about refreshing databases. And there are articles on automating this. The articles basically say - create a...

Yes you can use Dateadd in t-sql. With Dateadd, just use the interval or datepart as month and then pass in -1 to go back one month and -6 to...

There are quite a few examples of creating RDLC reports - take a look at these walk throughs and see if they help:

How to create RDLC report step...

I think you are looking in the wrong place - SSMS does not access files on the server to run any reports.  You need to look at permissions on...

Look at the data source for the report to find what is being executed. There are several different ways to capture or find the execution plan. This article goes through...