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
Kenneth Fisher
SQL and Azure Maze
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,957 reads
SQL Homework – May 2018 – Create a database
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
Stairway to Advanced T-SQL Crossword
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
2018-04-25
306 reads
What is a DBA?
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
Command shell steps in SQL Agent jobs only process a single command.
I was working on a SQL Agent job recently that required a series of command shell commands. And it would...
2018-04-23
923 reads
I’ve gotten a transaction log full error but when I look it’s not full??
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,288 reads
Exploring system tables, views, SPs etc
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
Fixing system database corruption with setup.exe
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
976 reads
Deleting a lot of data
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
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers