-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

A rant about presentations

My company’s internal conference is in a couple of weeks, so this seems like a good time to have a quick rant about some presentation failings I’ve seen over the last year or so.

If you want to, or are planning to present at a conference (or even just a… Read more

5 comments, 2,222 reads

Posted in SQL In The Wild on 24 April 2018

Revisiting catch-all queries

I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code. It turned into the 3rd most popular post ever on my blog.

A lot’s changed since 2009. When I wrote the original post, most production servers were SQL 2005 or… Read more

0 comments, 2,853 reads

Posted in SQL In The Wild on 13 March 2018

Obsessing over query operator costs

A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.

The percentages shown for operators in query plans are based on costs generated by the query optimiser. They are not times, they are not CPU usage, they are not IO. Read more

0 comments, 2,012 reads

Posted in SQL In The Wild on 13 February 2018

Books of 2016

I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to read anything

The full list, with Amazon links is at the end of this post, I’ll mention a few of the… Read more

2 comments, 400 reads

Posted in SQL In The Wild on 3 January 2017

Books of 2016

I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to read anything

The full list, with Amazon links is at the end of this post, I’ll mention a few of the… Read more

2 comments, 81 reads

Posted in SQL In The Wild on 3 January 2017

What is a SARGable predicate?

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for Search ARGument, and it means that the predicate can be executed using an index seek.

Lovely. So a predicate must be… Read more

5 comments, 89 reads

Posted in SQL In The Wild on 13 September 2016

What is a SARGable predicate?

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for Search ARGument, and it means that the predicate can be executed using an index seek.

Lovely. So a predicate must be… Read more

5 comments, 724 reads

Posted in SQL In The Wild on 13 September 2016

SQL Server 2016 features: R services

One of the more interesting features in SQL 2016 is the integration of the R language.

For those who haven’t seen it before, R is a statistical and data analysis language. It’s been around for ages, and has become popular in recent years.

R looks something like this (and I… Read more

2 comments, 607 reads

Posted in SQL In The Wild on 24 May 2016

SQL Server 2016 features: R services

One of the more interesting features in SQL 2016 is the integration of the R language.

For those who haven’t seen it before, R is a statistical and data analysis language. It’s been around for ages, and has become popular in recent years.

R looks something like this (and I… Read more

2 comments, 146 reads

Posted in SQL In The Wild on 24 May 2016

Upcoming conferences

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy an English summer.

InsideSQL

The InsideSQL conference is a new conference organised by Neil Hambly. It’s a deep-dive conference, with longer… Read more

1 comments, 233 reads

Posted in SQL In The Wild on 26 April 2016

Upcoming conferences

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy an English summer.

InsideSQL

The InsideSQL conference is a new conference organised by Neil Hambly. It’s a deep-dive conference, with longer… Read more

1 comments, 705 reads

Posted in SQL In The Wild on 26 April 2016

SQL 2016 features: Stretch Database

Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older, less used parts, to be stored in Azure instead of on local servers. This could be very valuable for companies that… Read more

4 comments, 2,443 reads

Posted in SQL In The Wild on 19 April 2016

SQL 2016 features: Stretch Database

Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older, less used parts, to be stored in Azure instead of on local servers. This could be very valuable for companies that… Read more

4 comments, 128 reads

Posted in SQL In The Wild on 19 April 2016

SQL Server 2016 features: Live query statistics

Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query to finish? Now you can.

Enable that and run a query, and you get an execution plan immediately, one with a few more details in it than we’re used to. Read more

0 comments, 121 reads

Posted in SQL In The Wild on 12 April 2016

SQL Server 2016 features: Live query statistics

Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query to finish? Now you can.

Enable that and run a query, and you get an execution plan immediately, one with a few more details in it than we’re used to. Read more

0 comments, 451 reads

Posted in SQL In The Wild on 12 April 2016

SQL Server 2016 features: Query Store

Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features.

The first one I want to look at is a feature that I’m so looking forward to getting to use, the Query Store.

Query Store is… Read more

0 comments, 685 reads

Posted in SQL In The Wild on 29 March 2016

SQL Server 2016 features: Query Store

Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features.

The first one I want to look at is a feature that I’m so looking forward to getting to use, the Query Store.

Query Store is… Read more

0 comments, 296 reads

Posted in SQL In The Wild on 29 March 2016

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.

The request was for more details on the method I use to capture wait and file stats on servers, The methods are pretty similar, so I’ll show waits.

This is by no… Read more

4 comments, 91 reads

Posted in SQL In The Wild on 23 February 2016

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.

The request was for more details on the method I use to capture wait and file stats on servers, The methods are pretty similar, so I’ll show waits.

This is by no… Read more

4 comments, 2,084 reads

Posted in SQL In The Wild on 23 February 2016

Q&A from the DBA Fundamentals Virtual Chapter presentation

A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from their site.

While I answered some questions during the presentation, I couldn’t answer all of them. Hence this blog post with the rest of the questions and some answers.

Q1:…

Read more

0 comments, 403 reads

Posted in SQL In The Wild on 16 February 2016

Older posts