Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the...
2011-11-21
654 reads
SQL RNNR
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script. Not a lot more to be said...
2011-11-21
5 reads
Table Space revised Again
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the...
2011-11-17
1,011 reads
Table Space revised Again
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the Table Space script that I have had out there...
2011-11-17
5 reads
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The...
2011-11-16
591 reads
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never...
2011-11-16
7 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what...
2011-11-15
840 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what I wrote here and here. Since writing those last...
2011-11-15
3 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far...
2011-11-14
1,032 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far as to enter my script into a TSQL Challenge....
2011-11-14
6 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
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?