I last posted about changing a table without changing a view that represents the table and how this may affect the view.
In today’s quick post I’d like to show another issue brought about by not maintaining your views.
Tag: Development
Don’t forget to drop your views
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.
SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.
SQL Server vs Oracle: Substring
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases for a while, I’m sure you’ve had to parse a string and while you’d think these are the same they work a little different and I think Oracle may surprise you a bit.
SQL Server vs Oracle: How to replace NULL values
It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real pain. Don’t worry though there’s a simple solution. Simply replace the NULL value with another.
SQL Server vs Oracle: Convert string to date
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked at date formatting, end of month, top rows, and pagination.
SQL Server vs Oracle: Pagination
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing large amounts of data to the application and expecting the application code to figure out which rows it needed to display.
SQL Server vs Oracle: Top N rows
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are for retrieving the top number of rows.
SQL Server vs Oracle: End of Month
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from some time and has only just recently appeared in SQL Server.
SQL TECH BLOG 