Category Archive: SQL

Oct 14

PASS Summit 2016! The best one yet?

In a little over a week, I will be attending my 3rd PASS Summit. Over the past 2 years I have been lucky enough to attend the PASS Summits (2014 and 2015) and 2 SQL Cruises. I have made it my goal to attend these 2 things each and every year for a number of …

Continue reading »

Aug 09

SOLVED: “There have been <N> misaligned log IOs which required falling back to synchronous IO. The current IO is on file <logfilename>.” – Trace Flag 1800

Do you have an Availability Group set up that is seeing some strange latencies or behaviors? Have you looked at the error logs on your replicas and seen this? There have been <N> misaligned log IOs which required falling back to synchronous IO. The current IO is on file <LogFileName>. What the heck does this …

Continue reading »

Feb 25

Extracting Procedure Name from Cached Plans

The other day, a friend of mine shot me an email asking how he could extract the procedure name from cached plans. He was using the query I referenced from Jonathan Kehayias to get subtree cost, but he really wanted to see which procedures aligned with which cost. I assume this was to look at …

Continue reading »

Jan 07

So you want to learn SQL Server? – Part 2

In Part 1 of this series, we learned how to do a very basic install of the free version of SQL Server (Express Ed.) in order to start learning the basics. In Part 2, we will be downloading a sample database called AdventureWorks that we can attach to our SQL Server instance and begin using right …

Continue reading »

Nov 12

So you want to learn SQL Server? – Part 1

After attending the PASS Summit last week, I really got pumped to start blogging and speaking. I wanted to talk about spinlocks and latches, parsing xml, and PowerShell. However, I realized that there are so many people out there that want to get started in SQL, but don’t know where to start. Inspired by my …

Continue reading »

Mar 26

How to move data or a table from one data file to another in the same filegroup! – Part 2 of 2

This post is a continuation of the previous post, How to move data or a table from one data file to another in the same filegroup! – Part 1 of 2, and will show you how SQL handles data when it has more than 1 file. I will show you what happens when someone adds a second …

Continue reading »

Mar 20

How to move data or a table from one data file to another in the same filegroup! – Part 1 of 2

Sorry! This isn’t something you can do. I wanted to title this post in a way that would draw people to it for my rant. I am ranting because I had a friend who went to an interview where he was asked how you move data from one file to another. He didn’t know, so …

Continue reading »

Mar 02

My Experience on SQL Cruise Caribbean 2015

Other SQL Cruise Links: SQL Cruise Caribbean 2015 Recap – Patrick Keisler Caribbean: The Final SQL Frontier – Mickey Stuewe SQL Cruise Caribbean 2015 Wrap Up – David Klee SQL Cruise Caribbean 2015: More Than A Cruise With Classes. Much More. – Jes Borland   This year I had the amazing opportunity to attend SQL Cruise …

Continue reading »

Apr 26

Determining a setting for “Cost Threshold for Parallelism”

I was asked to share this after a discussion at SQLSaturday Chicago by a presenter, David Klee. So, thank you David for getting me to finally post something! A while ago, I was tasked with researching Max Degree of Parallelism and Cost Threshold for Parallelism settings for my company’s SQL Servers. While trying to find …

Continue reading »

Mar 01

Existing Instance Not Available for Upgrade/Repair/Remove

Yesterday we ran into an issue when upgrading one of our SQL Server 2008 R2 instances to SQL Server 2012.  We ran the install as normal with the upgrade option.  When it came time to choose the instance and features to upgrade, the only options were the shared features.  What happened to our Database Engine …

Continue reading »

Older posts «