CJ, the server level fillfactor is set to 100% Config and run values are at 0, which is the same as 100%.

name ...

1. Add Logins for BI team to primary instance

2. Add Users to relevant databases for BI Team Logins and grant permissions to new Users

3. Drop Logins from primary instance <-...

I did more digging and found an answer here. Looks like I have to switch to replication to get what I am after.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47434c9b-f000-4a59-8a43-9d05bc4cc8f2/separate-permissions-on-log-shipping-primary-and-secondary-databases?forum=transactsql

LearnSQL!!! (1/5/2016)

---

I'm planning to upgrade from SQL Server 2008 (Server name -A ) to SQL Server 2014 (Server name - B), when restoring databases to...

In our case we can recreate the data going into the staging database because we have the original files used to populate the tables at the beginning of the process....

Definitely helpful feedback and it assures me that I was on the right path I just needed to confirm that if possible.

As for the use of SSIS, I encouraged a...

Thanks for the feedback Jeff. As you noted, my primary database is in the FULL recovery mode. The fact of all this activity being logged in the staging...

SoHelpMeCodd (12/28/2015)

---

The answer depends upon what resources you can offer, and what risks you are willing to take. I would prefer to create an ETL server on its own OS...

Thanks Phil and Kevin. By focusing on what columns were in the indexes I was missing that the clustered index is all the table data ordered logically at the...

If the clustered and NCI are the same column how would reading the NCI be fewer pages to access?

I'm getting this when I execute the proc from SSMS.

Msg 512, Level 16, State 1, Procedure CustomLogShippingRestore, Line 166

Subquery returned more than 1 value. This is not permitted when the...

This is working for me fine on one Secondary but on another I get the error below.

Error converting data type nvarchar to bigint. [SQLSTATE 42000] (Error 8114). ...

Johnny, If you are looking for a third party tool, SolarWinds DPA is a good one. I currently use it and it is helpful. Not only will it...

I would review the below from the SQL Server Customer Advisory Team. The article addresses the issues below:

(1) How can I find out whether my indexes are useful? ...

A quick search of the data in the error message turned up the links below. You might try doing your own searching and let us know what you have...