Not In v Not Equal
Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.
2008-03-12 (first published: 2007-05-29)
22,085 reads
Ken Johnson
Securing the SA Account in SQL Server 2005
SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks
you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account.
2008-02-20 (first published: 2007-03-14)
16,528 reads
Blogs
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Tomorrow: Webcast on SQL Server security
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
Forums
Difference between equal directly and use SUBSTRING
Hello, I have a script that was running really long, and I have found...
Visualisation options as an alternative to SanKey diagram
I am building a report to show customer journeys and their arrears levels. I...
should i prefer join or left join over exists or in
hi, I have seen people use exists when exists is required and no cols...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers