SQL SERVER BLOGS
- General (10)
- Tables and columns (11)
- Selecting data (7)
- WHERE criteria (5)
- Calculations (7)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (5)
- Programming tables (4)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (3)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on General in SQL
Showing blogs 1-9 (out of 9)
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.
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.
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.
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.
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.
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!
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.