Comparing the contents of two tables
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,573 reads
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,573 reads
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
499 reads
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them....
2016-05-04
925 reads
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,639 reads
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need...
2016-04-27
2,578 reads
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new...
2016-04-25
1,825 reads
Me: I think I’m going create a new playground instance.
Myself: Make sure you use a case sensitive (CS) collation when...
2016-04-20
414 reads
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
469 reads
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,675 reads
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
497 reads
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...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
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
Comments posted to this topic are about the item Eight Minutes
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?