NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.
How long does it take to create to 100 staging packages? The answer will shock you!
Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
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...
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?