What is the database property “Compatibility Level”
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
661 reads
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
661 reads
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,563 reads
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS...
2015-07-03 (first published: 2015-06-29)
1,707 reads
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...
2015-06-30 (first published: 2015-06-24)
2,074 reads
TLDR; Search for and modify the sqlfile.sql file.
During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET NOEXEC...
2015-06-23 (first published: 2015-06-11)
3,105 reads
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...
2015-06-22
910 reads
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an...
2015-06-17
660 reads
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,325 reads
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
606 reads
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,848 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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?