SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
2009-01-08
2,732 reads
Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.
2008-12-31
1,345 reads
2008-12-29
4,034 reads
Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.
2008-12-22
5,822 reads
2008-12-15
4,271 reads
2008-12-09
4,052 reads
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
2008-12-01
9,159 reads
2008-11-27
4,107 reads
2008-11-26
4,939 reads
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
2008-11-24
10,748 reads
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Hi Everyone, I have a question, I am trying to setup a Lab environment...
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Comments posted to this topic are about the item Elements of the SQL Server...
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers