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
914 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,353 reads
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
972 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 Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?