Default Database Reports – Disk Usage by Table
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,832 reads
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,832 reads
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...
2017-08-02 (first published: 2017-07-17)
1,389 reads
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
416 reads
I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware...
2017-07-31
578 reads
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,627 reads
Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.
2017-07-26
938 reads
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
458 reads
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,068 reads
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...
2017-07-11
439 reads
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,424 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?