Without knowing a lot more about how the system and that database came to be in that state - the easiest method to clean it up would be to re-add...

Ya gotta be careful, though.  If you do the index maintenance incorrectly, you could be setting up the index to do massive page splits which will cost you dearly...

Even moving everything to a single database probably will not resolve the licensing issue.

If you are exceeding the allowable concurrent connections and you want to create more than the allowable...

If your databases stop synchronizing - then you have additional issues with those databases.  You need to figure out why those databases have stopped synchronizing and address those issues.

Look into...

I will add that rebuilding indexes is not about performance - and should not be considered as a method to improve performance.  Index maintenance is about resource usage.

How much wasted...

Can you explain further why you want to allow this user to enable/disable system versioning?  As far as I am aware - the only reasons to temporarily disable...

Can you explain further why you want to allow this user to enable/disable system versioning?  As far as I am aware - the only reasons to temporarily disable versioning is...

I would add a RANK or DENSE_RANK to your query based on the customer ID and create a table to hold the results.  You can then use that ranking column...

If you use the command line with SqlPackage.exe - one of the options available is a log file.  Instead of importing using SSMS - use the command line with the...

Sounds good.

You need to get into a mindset that "If I create a new SQL login, I must run sp_help_revlogin, to script the login for the secondaries", adds an...

This can be done using SwePeso's method - without using PARSENAME:

SELECT Total = CONCAT(SUM(t.sec) / 60, ':', SUM(t.sec) % 60)
  FROM (VALUES ('23:01'),('00:01'),('05:15'),('00:45'),('00:11')) AS td(Trip_Duration)
 CROSS...

• This reply was modified 2 years, 7 months ago by Jeffrey Williams.

Unless I am missing something - the problem is this: hdmhdr.dmdstat = 'A'

The right join is also joining to this table - and in a right join it is the...

Let me clarify - index maintenance might help if the tables are highly fragmented now, causing additional IO and memory to be utilized.  It won't directly help performance because index...

I read through this - and seriously, if...

This is one of those questions where the OP says "This is what I want" and it leaves me begging to ask "Yeah... but it that what you really...