believe

The article I linked to answers #2 and #3 quite well.

To move a heap to a new filegroup create a new heap with a...

I wouldn't worry about 752 but I would definitely change from 10% to something in MB. I use 128MB by default. Then shrink your file once to a sensible size...

Good deal. Thanks for posting back that it was sorted.

You're welcome. Thanks for the feedback.

A connection method of...

You're welcome. Thanks for the feedback.

That's not a PowerShell thing per se. What that is saying is:

echo textToPipeIn | executableName executableOptions

Which works fine in cmd Shell as well. How to pipe in more than one...

It's part of the RAISERROR function, you say WITH LOG and SQL Server will additionally write the error to the SQL Error...

I would not rely on RAISERROR writing to the event log. SQL Server no longer does that in SQL Server...

That makes perfect sense. You can now use DBCC SHRINKFILE (once) to reclaim log space. The command can be blocked from shrinking the file for various reasons so post back...

What do you mean by "working method"?

SSMS will function as usual, but it will be "running as" the Administrator so will be setup using the Administrator's preferences, e.g. their Registered...

Here is good info on how to "rebalance" the data in your data files, and why you should do it that way:

http://www.sqlmag.com/blog/sql-server-questions-answered-28/database-administration/rebalancing-data-files-filegroup-140068

That will get you rows. You'll also need a Cross-tab to bring it back as columns:

WITH cte ( ID, Name )

...

These are the English messages that get logged automatically.

SELECT *

FROM sys.messages

WHERE language_id = 1033

AND (

...