Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
2019-06-06 (first published: 2019-05-20)
987 reads
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
2019-06-06 (first published: 2019-05-20)
987 reads
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading
2019-06-03
26 reads
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are ... Continue reading
2019-05-30
59 reads
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! ... Continue reading
2019-05-27 (first published: 2019-05-14)
477 reads
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
533 reads
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway ... Continue reading
2019-05-17
13 reads
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What ... Continue reading
2019-05-08 (first published: 2019-04-29)
1,237 reads
If you have to deal with linked servers then you probably have or will run into the following error: Login ... Continue reading
2019-05-08
89 reads
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
2019-05-06 (first published: 2019-04-22)
1,593 reads
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
19 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?