CREATE SCHEMA can do what?!?!?
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,122 reads
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,122 reads
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,848 reads
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,916 reads
2013-05-08
1,348 reads
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
911 reads
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
805 reads
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,573 reads
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...
2013-04-24
737 reads
I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...
2013-04-22
811 reads
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,208 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers