I seem to recall that IT Researches uses SQL 2008 R2 Express. The space needed for tempdb is 20 GB which is above the database limit for Express. I am...

What sort of foreign key do you have in mind? The XML column itself cannot be a foreign key, since you cannot have an index, and thus not a primary...

What is really optimistic is that you expect that someone without knowledge about your system would know where these files are located on this machine. If someone told you that...

I might have missed something, but I have never heard that Linux comes with a database. Maybe you could clarify?

Or do you mean an SQL Server database running on Linux?...

Also, I thought running a query in the select portion caused multiple queries for each result - is this wrong?

Keep in mind that SQL is a declarative language. You tell...

I would do this with an EXISTS check in the SELECT list:

SELECT
        cn.noteID,
       ...

It's hard to comment without seeing the details. But it may be better to do something like this in a client-side language. Python, Powershell,Perl or C# are all more powerful...

No. This is T-SQL. It's not Perl or Python.

But tell us what you really want to achieve, that is, what drove you to ask these question in the first place?...

No.

DOCUMENT means that the xml must be a valid XML document and not just a fragment. That is, there must be one single root node around the whole thing. The...

; WITH numbering AS (
    SELECT cUser, dDate, dense_rank() OVER(PARTITION BY cUser ORDER BY dDate) AS drank
    FROM   #tmp_UserDates
)
SELECT...

Indeed, there would if the connections would be physically opened and closed for every edit. That is why client APIs implement connection pooling as a default option to prevent this...

To answer your question: you may not have to restart SQL Server. You can connect on the admin connection. You do that by prefixing the server\instance with ADMIN:, for instance

ADMIN:.\SQLEXPRESS

By...

Connection pooling is a client-side concept. When you close a connection, the API keeps the connection and reuses it when the same connection string is used again. SQL Server has...

12000 connections on an Express instance sounds an awfully lot. As a matter of fact, it is an awfully lot even for Enterprise Edition. I've never seen that many.

Does this...