I've never heard of anything like that in SQL Server.

Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I...

(1) Not guaranteed, but you could try looking at sys.dm_exec_input_buffer.event_info (SQL 2016+ only, I think).  I would issue this command immediately upon entering the trigger, to have the best chance...

It may fragment some indexes and not others.  You certainly don't want to automatically rebuild every index.  Also, rebuild from smallest to largest of the indexes that do need rebuilt.

Liked Rune's comment.

And that is why you should always explicitly specify NOT / NOT NULL when creating a table.  From the context of the q, I could work out that...

Shrink only the file(s) that are part of the PRIMARY filegroup:

DBCC SHRINKFILE(1, 512)

DBCC SHRINKFILE(?, 512) --if you have additional file(s) in the PRIMARY fg

SELECT CAST(SUM(OrigWeight/2000.0) AS decimal(10,2)) Tons

SELECT OBJECT_NAME(object_id) AS object_name
    SUBSTRING(definition, CHARINDEX('##', definition) - 20, 200) AS definition_first_match,
    definition
FROM sys.sql_modules
WHERE definition LIKE N'%##%'
ORDER BY 1

Edit: Sorry, I...

• This reply was modified 3 years, 6 months ago by ScottPletcher.

SQL will take only those locks needed to guarantee consistency and accuracy in results.  As Jeff said, the details of that depend, but that is the general approach.

Is A an...

Do you -- the user running the code -- also have sysadmin permission?  If you have sysadmin permission, any DENYs are ignored.

Search for '##' in the text of the proc.  The only real reason that string should be in there is to reference a global temp table.

The PARTITION SCHEME tells SQL which filegroups to use for the partitions.

would you care to...

would you care to explain exactly...

There are a number of restrictions and possible gotchas with filtered indexes.  In theory they are great, in practice they can be difficult.

Until you've had time to fully test out...