SQL Server 2014

/Tag:SQL Server 2014

SQL 101: Two places to start troubleshooting

By | 2017-12-31T08:28:03+00:00 January 3rd, 2018|Categories: Troubleshooting|Tags: , , , , |

Getting started Someone calls you at 1 AM on Saturday and says, "Is there an issue with SQL?" First, breath and take a look at your logs. This post is about two places you can take a look to see if there's an issue, quick, so you can get back to sleep. Especially when I was [...]

Using Live Query Statistics on older SQL Servers

By | 2017-06-12T16:56:28+00:00 June 12th, 2017|Categories: Uncategorized|Tags: , , , , |

First, thanks to everyone who attended my session at SQL Saturday #634 Iowa City! I spoke about execution plans and how to begin reading them. Here's a link to my session. I had an attendee come up afterwards who mentioned that Live Query Statistics could be used with the newest version of Management Studio to watch [...]