Blogs from Wise Owl on General in SQL

Wise Owl have found one SQL structure which slows down code more than any other

Posted by Andy Brown on 13 May 2019

If your stored procedures or SQL queries are running slowly, don't bother looking at correlated subqueries, cursors, functions or any of the other usual culprits. There's one SQL syntax which Wise Owl have found to be an order of magnitude worse than any other, as this blog shows.

Create your own snippets of SQL code, and insert them into your queries

Posted by Andy Brown on 23 November 2017

With SQL Server 2012 came the power not just to use pre-defined code snippets, but also to create your own - this blog explains how.

Wise Owl coding standards for T-SQL (the SQL dialect used in SQL Server)

Posted by Andy Brown on 01 February 2017

A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.

How to use the FOR XML keywords in SQL to concatenate ids

Posted by Andy Brown on 27 September 2016

If you want to group items in a SQL query, showing a comma-delimited list of ids for each, generating an XML file is not the obvious place to start - but it should be.

Wise Owl suggestions for new features for SQL Server Management Studio

Posted by Andy Brown on 09 September 2013

Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!

Exporting data from SQL Server Management Studio

Posted by Andrew Gould on 04 February 2013

While SQL Server Management Studio is a powerful tool for writing queries, it has absolutely no concessions towards making the results of those queries remotely presentable! This blog describes several techniques for getting the results of a query into another application so that you can format them to your heart’s content.

New in SQL 2012 - code snippets and surrounding code

Posted by Andy Brown on 15 May 2012

In a previous blog on new features of SQL 2012, I missed out the ability to insert code snippets, and also to embed or surround code in an IF, BEGIN or WHILE block. This blog rectifies this!

New features for SQL within SQL Server 2012

Posted by Andy Brown on 08 May 2012

SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.

Access project ADP file extended properties error

Posted by Andy Brown on 04 January 2011

When you try to view data for a table in an Access project with an ADP extension, Access can throw a wobbly. Here's why!