Each session should be able to have its own temp table, but there can be problems.
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
985 reads
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
985 reads
Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found...
2018-05-08 (first published: 2018-04-30)
1,956 reads
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...
2018-05-02
257 reads
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
2018-04-25
304 reads
If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA...
2018-04-25
327 reads
I was working on a SQL Agent job recently that required a series of command shell commands. And it would...
2018-04-23
910 reads
Every now and again I’ll get an error telling me a transaction log is full. This can be for any...
2018-04-23 (first published: 2018-04-16)
2,287 reads
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have...
2018-04-18
1,352 reads
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
970 reads
I recently had the task of deleting a bit over a billion rows from a table. Now I could have...
2018-04-12
2,107 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A:
B:
See possible answers