Find out what is causing the compile.

Could be an application sending text down the line with the parameter values in the string.

Could be a proc with DSQL that also has...

What version of SQL do you have?

If you have enterprise, you can create a partitioned table.

Partitioned in such a way that old data won't be modified if you can.

Then in...

I did something similar with a 500GB table.

The table had no index, so I needed to create a clustered index on the table for partitioning.

50GB free and no space on...

Mirroring still exists. Also, MS cannot remove mirroring unless they have a version of HA which will replace Mirroring.

So Mirroring will always be there, albeit, as a poor man's DR...

From MSDN

FIRSTROW = first_row , Specifies the number of the first row to load. The default is 1. This indicates the first row in the specified data file. The row...

Just doing a favour for other SSC Members.

Ok, I have some stored procedures that are using EXEC and I am updating them to use sp_executesql instead.

In the same proc, I've...

Look for Adam Machanic's SP_WhoIsActive.

This gives you the queries running, as well as resources being used, and whether the query is blocked.

He has a specific one for Azure.

http://sqlblog.com/blogs/adam_machanic/archive/2015/04/10/sp-whoisactive-and-azure-sql-database.aspx

You would create 2 contraints, one on each column to ensure that the not null values have a 1 to 1 relationship to each other.

2 unique constraints would be best,...

When you say 'does not complete' do you mean started longer than a threshold ago and is still running, Or was timed out from the application?

You can find the longest running couple of procs in sys.dm_exec_procedure_stats, order by 1.0*total_elapsed_time/execution_count desc.

Have a look at the query plan.

i.e., find a test case, execute it with View actual...

Thanks for example of data.

Example of expected result?

Concatenate with FOR XML PATH.

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

https://gallery.technet.microsoft.com/scriptcenter/SQL-Script-to-list-VLF-e6315249

This maybe?

SELECT

b.groupname AS 'File Group',

Name,

[Filename],

CONVERT (Decimal(15,2),ROUND(a.Size/128.000,2))

[Currently Allocated Space (MB)],

CONVERT (Decimal(15,2),

ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2))

AS [Space Used (MB)],

CONVERT (Decimal(15,2),

ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2))

AS [Available Space (MB)]

FROM dbo.sysfiles a (NOLOCK)

JOIN sysfilegroups b (NOLOCK) ON a.groupid = b.groupid

ORDER BY...

concatenate using FOR XML PATH.

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string