Can a transitive dependency be a non-key determinant having a non-key attribute?

1. If a table was in 1NF and had non-key attributes with trivial transitive dependencies on candidate keys, could it be in 3NF? I think it could if...

Here is the definition of 3NF:

"A relation R is in 3NF if and only if (i) it is in 2NF and (ii) whenever X is a set of attributes of...

PreviousJobTitle is 0% dependent on the primary key in my example. Was that not clear?

If the table were changed and PreviousJobTitle were dependent on PersonID2 (instead of JobTitle) would it...

System monitor in Windows could help. I don't know what version of Windows you are running. I would set up some logging of network traffic with sysmon on both...

One thing to remember is that truncating a table is not a DML operation (like DELETE). Truncating is a DDL operation. So transaction logging doesn't occur when a TRUNCATE...

A subquery could run in O(k) time which is very fast. In fact, it could be merely a mathematical operation (e.g., 1+1). But it could run in O(n!)...

See if the queries don't need to sort all those rows. Re-writing the query to filter out certain rows could help. But I don't know what your needs...

I probably won't be converting to or from HierarchyId. I'm just curious. If someone wants to answer this thread for the theoretical fun, please do.

I want the reserved words with the definition. Microsoft's website is great except that I have to print each word (@@transcount, GO, ISNULL()), one at a time. I...

Thanks for the responses.

I have a question about this response:

"pls check any inner query take more time that time you will use temporary tables."

Can you rephrase this? Could...

When writing SQL code, which would be preferable from a readability perspective given these two examples which I believe are identical in terms of performance:

1.

DECLARE example varchar(8)

CREATE FUNCTION...

Microsoft says that LSNs are integers assuming Microsoft Press speaks for them. In Microsoft SQL Server 2008: Implementation and Maintenance Self-Paced Training Kit by Michael Hotek and published by...

Could the OS performance monitor be reporting on the applications besides SQL Server? Some servers are nearly dedicated to SQL Server. Windows Small Business servers lend themselves to...

The canonical answer would be a LUN that is using RAID1. The underlying hardware configuration of the LUN would be relevant for your determination. The tempdb may take...