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
306 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
328 reads
I was working on a SQL Agent job recently that required a series of command shell commands. And it would...
2018-04-23
918 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,355 reads
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
975 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,108 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers