Fun with Outer Joins
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
2014-01-17 (first published: 2012-09-10)
23,272 reads
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
2014-01-17 (first published: 2012-09-10)
23,272 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
898 reads
So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an...
2014-01-13 (first published: 2014-01-06)
7,511 reads
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,401 reads
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
632 reads
On the first day after release my developer gave to me
a performance problem on a crucial query
On the second day...
2013-12-24
787 reads
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
683 reads
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
667 reads
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,522 reads
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....
2013-12-10
853 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?