(page bump needed?)

You could easily have an order of magnitude more rows in SG table than in T, and if you have a phone app waiting for the response, I would still...

Nice.

Also, you don't have to change the FKs in other tables if you need one for just ID.  Instead, just add a unqiue nonclus index on ( ID ); it...

> What difference the client is a phone? <<

Because to determine all the Tests that haven't been fully graded could require scanning a very large number of StudentGrade rows.

If, instead,...

I would use option 2 in this case.  The safest way to set the flag consistently accurately is to use a trigger on the StudentsGrade table.

SQL captures the size of backups in table msdb.dbo.backupset.  Thus, you can query that table to add up total space used for backups.

You could do as below.  You can't really GROUP BY ID, because that would separate the Small, Medium and Large into separate rows.

SELECT    ...

How is one to know when it's, say, 8AM or 9AM, and the last entry for a person was at 2AM, whether future entries were missed or the person is...

IF you're on Enterprise Edition, you can do an online build of an index for SpoolStartDt.  Then you can use that index to do the DELETEs.  If you're not on...

I haven't ultra-tuned this, but see if it gives you the correct results.

;WITH
cte_tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally_hrs AS (
 ...

Maybe?:

SELECT SYMBOL1, SYMBOL2
FROM (
    SELECT SYMBOL1, ROW_NUMBER() OVER(ORDER BY SYMBOL1) AS row_num_1
    FROM #STOCKS1 S1
    WHERE NOT EXISTS(SELECT...

Since it's not an index seek, partitioning should still help the query by reducing the number of pages it has to search.  Once again, verify that by looking at the...

It's just a predicate / search, it's not an index SEEK.

Interesting.  Look at the query plan and see if it is doing a SEEK as part of the clus index scan.  I'll read up on the mechanics of row-level security...

I'll address your qs/ concerns as (A) ["Does partitioning ..."], (B) and (C):

(A) Yes, absolutely.  You only need to partition then for other aspects, such as manageability.

(B) In the vast...