210 blogs updated: 39 min. ago
SQL Server (47) PostgreSQL (56) MySQL (27) Oracle (72) Mishmash (6)
Row Goals Part 2: Semi Joins
It is relatively well-known that using TOP or a FAST n query hint can set a row goal in an execution plan (see Setting and Identifying Row G...
22-02-2018 16:28:45 SQL performance (sqlsentry) SQL Server
Using WITH (NOEXPAND) to Get Parallelism with Scalar UDFs in Indexed Views
Scalar functions are the butt of everybody's jokes: their costs are wrong, their STATS IO results are wrong, they stop parallelism when they...
22-02-2018 16:17:50 Brent Ozar SQL Server
Altering table types, part 2
Altering table types - a compatibility guide In yesterday's post, I altered a table type. Pray I don't alter them further. What else is inco...
22-02-2018 16:16:09 Bill Fellows SQL Server
Huge Pages
A useful quick summary from Neil Chandler replying to a thread on Oracle-L: Topic: RAC install on Linux You should always be using Hugepages...
22-02-2018 10:57:48 Jonathan Lewis Oracle
Use Time-Related Words With Caution
I've come to see time-related words as potentially dangerous to use in writing, because they have ambiguities that are difficult to parse. I...
22-02-2018 04:24:32 Baron Schwartz (xaprb) MySQL
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
One of my clients contacted me for quick On-Demand consulting. When I joined GoToMeeting with them they showed me below error when they were...
22-02-2018 03:00:39 Pinal Dave SQL Server
Percona XtraDB Cluster and SELinux: Getting It To Work
In this blog post, I'll look at how to make Percona XtraDB Cluster and SELinux work when used together. Recently, I encountered an issue wit...
21-02-2018 21:47:08 Percona MySQL
Using the Slack webhook API from PL/SQL
Slack is a web-based chat room popular with many companies. Slack also has an API that can be used to post messages to a given "channel" or ...
21-02-2018 21:38:29 Morten Braten Oracle
Testing Database Changes the Right Way
Under the hood, Heap is powered by a petabyte-scale cluster of Postgres instances. Our dataset is large, and our customers run a wide variet...
21-02-2018 20:10:25 Heap Analytics PostgreSQL
Pop quiz - altering column types
Pop quizGiven the following DDL CREATE TABLE dbo.IntToTime ( CREATE_TIME int ); What will be the result of issuing the following command? AL...
21-02-2018 18:57:24 Bill Fellows SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.