Viewing 15 posts - 46 through 60 (of 1,199 total)
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...
May 6, 2021 at 8:37 pm
I would do this with an EXISTS check in the SELECT list:
SELECT
cn.noteID,
...
May 6, 2021 at 7:59 pm
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...
April 29, 2021 at 7:09 pm
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?...
April 29, 2021 at 6:29 pm
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...
April 24, 2021 at 8:34 am
; WITH numbering AS (
SELECT cUser, dDate, dense_rank() OVER(PARTITION BY cUser ORDER BY dDate) AS drank
FROM #tmp_UserDates
)
SELECT...
April 8, 2021 at 1:11 pm
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...
March 8, 2021 at 7:39 am
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...
March 6, 2021 at 9:26 am
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...
March 4, 2021 at 7:28 am
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...
March 3, 2021 at 10:39 am
The answer to performance question like this one is often "it depends". For one thing "name contains 'ram'" is not legal SQL syntax, so it depends on what you mean....
February 27, 2021 at 9:49 am
I don't really know what PageMemorySize might be; I don't see it in my Task Manager. Which OS and bitness are you on? What exactly does "SELECT @@version" report?
But as...
February 1, 2021 at 6:55 pm
So type the correct name. Don't forget the instance name, if it is a named instance.
You say that you are on a different network, so the server you are trying...
January 25, 2021 at 7:14 pm
Doesn't the dropdown permit you to type a name?
I'm sorry, I don't know where in Excel this dropdown may be hiding, so I can't test myself.
January 25, 2021 at 6:36 pm
Viewing 15 posts - 46 through 60 (of 1,199 total)