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...
2017-08-11
599 reads
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
599 reads
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing...
2017-08-10
388 reads
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...
2017-08-09
285 reads
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...
2017-08-08
288 reads
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
289 reads
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
403 reads
Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...
2017-07-28 (first published: 2017-07-14)
7,315 reads
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
240 reads
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...
2017-06-29
885 reads
It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be...
2017-06-22
426 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers