Do you mean the session is sleeping or a session whose connection has already been closed?

You can use the following script to find the login names of all connections:

select session_id,...

What do you see when you check the following DMVs for the session ID of the shrinkfile operation?

sys.dm_exec_requests

sys.dm_os_waiting_tasks

What result do you get when you run the following script in a...

You created the clustered index on the primary filegroup instead of on the partition scheme. By doing this, you are effectively removing the partitioning. You can confirm this...

USE [AdventureWorks2012]

GO

SELECT t.TABLE_SCHEMA, t.TABLE_NAME, c.COLUMN_NAME, c.DATA_TYPE, t.TABLE_TYPE

FROM INFORMATION_SCHEMA.COLUMNS c

INNER JOIN INFORMATION_SCHEMA.TABLES t

ON c.TABLE_NAME = t.TABLE_NAME AND c.TABLE_SCHEMA = t.TABLE_SCHEMA

WHERE (DATA_TYPE IN ('FILESTREAM','XML','VARBINARY','TEXT','NTEXT','IMAGE')

OR(DATA_TYPE IN ('VARCHAR', 'NVARCHAR') AND...

There should be a corresponding SQL:StmtStarting event for any query using parameters that first declares the value of the parameters.

For the sp_execute example, you should see a RPC:Starting event but...

sp_clean_db_file_free_space removes ghost records - records that have already been deleted. This is unlikely to be your problem. Have you checked which tables are consuming the space and...

You can set up a server-side trace for the event SQL:StmtStarting and filter on the textdata column to look for something like "%SELECT * FROM %schemaName.viewToBeAltered%". Depending upon how...