Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,036 reads
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,036 reads
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,511 reads
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
688 reads
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,338 reads
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,165 reads
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
841 reads
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
886 reads
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,619 reads
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,050 reads
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
1,942 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?