Profile

Cover photo
Wayne Sheffield
138 followers|8,749 views
AboutPostsPhotosVideos

Stream

Wayne Sheffield

Shared publicly  - 
 
This post is re-published from my original post on SQL Solutions Group. I hope that you enjoy it. In my last article, I started off talking about checking various settings that make a performance difference prior to jumping into query tuning. This article…
How would you like to make a single change to your system and improve your IO performance by up to 40%? Read on to find out how!
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
Service Packs and Updates One of the things that I always check on client servers is that they are running the latest service packs, for both SQL Server and for the Windows OS itself. Now, sometimes I know what the latest service pack is – but other times…
SQL Server and Windows service packs (and updates), for as far back as I can find.Includes download links and tables.
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
This post is re-published from my original post on SQL Solutions Group. I hope that you enjoy it. When investigating a performance issue, the desired end result is already known… you need to make the queries run faster. It’s been my experience that most…
This post is re-published from my original post on SQL Solutions Group. I hope that you enjoy it. When investigating a performance issue, the desired end result is already known… you need to make the queries run faster. It’s been my experience that most performance problems involve optimizing
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
It’s been a while since I’ve written a T-SQL Tuesday post, mainly because I just wasn’t inspired by the topic. And truth be told, this one was turning out to be that way also. But then today, I was wishing that SQL Server would track something that it…
It's been a while since I've written a T-SQL Tuesday post, mainly because I just wasn't inspired by the topic. And truth be told, this one was turning out to be that way also. But then today, I was wishing that SQL Server would track something that it doesn't do, and I realized that I had a
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 21. In this challenge,you received a present – a role…
source: http://cdn2.pcadvisor.co.uk/cmsdata/features/3380127/Infinity_Blade_II.jpg In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I'm going through the days, solving both parts of each puzzle. Continuing on, today we have day 21. In this
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 19. In this challenge, Rudolph is sick and needs some…
source: http://www.brockpress.com/wp-content/uploads/2014/11/RudolphandSanta.jpg In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I'm going through the days, solving both parts of each puzzle. Continuing on, today we have day 19. In this
1
Add a comment...
Have him in circles
138 people
William Bennett's profile photo
Karen Lopez's profile photo
Andie Letourneau's profile photo
Samuel David's profile photo
Michael Albert's profile photo
Alvin Ramard's profile photo
Kevin Kline's profile photo
Boris Hristov's profile photo
Rob Lepard's profile photo

Wayne Sheffield

Shared publicly  - 
 
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about a specific topic. This month, the host is my friend Jason Brimhall (b/t). The topic that he has selected is “Sharpen Something”. Specifically, he wants us to:…
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about a specific topic. This month, the host is my friend Jason Brimhall (b/t). The topic that he has selected is “Sharpen Something”. Specifically, he wants us to: I am asking you to not only write …
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
I’m happy to announce that I’ll be going on a Central Texas SQL Tour in mid-August. First up is the San Antonio SQL Saturday – I’ve been selected to be a speaker. This is really special because this is San Antonio’s first ever SQL Saturday!!! I’ll be…
I'm happy to announce that I'll be going on a Central Texas SQL Tour in mid-August. First up is the San Antonio SQL Saturday - I've been selected to be a speaker. This is really special because this is San Antonio's first ever SQL Saturday!!! I'll be presenting what is probably my favorite
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
Recently (okay, it went live a month ago, and I’m super-late in my blog post!), I was the guest on the podcast that Carlos Chacon of SQLDataPartners publishes. In this podcast, we talk about Table Variables and Temporary Tables (if you’ve been to one of…
Recently (okay, it went live a month ago, and I'm super-late in my blog post!), I was the guest on the podcast that Carlos Chacon of SQLDataPartners publishes. In this podcast, we talk about Table Variables and Temporary Tables (if you've been to one of my presentations on this topic, then you know
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
One of the nightmare scenarios that a SQL Saturday organizer faces is selecting a speaker that is already going to another event on the same day. The speaker can only be at one event… and the site doesn’t really help us out with letting us know about…
source: http://thistimeimeanit.com/wp-content/uploads/2011/06/officejuggler.jpg One of the nightmare scenarios that a SQL Saturday organizer faces is selecting a speaker that is already going to another event on the same day. The speaker can only be at one event... and the site doesn't really help
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 20. In this challenge, it seems that Santa’s elves have…
source: http://www.myphillyalive.com/wp-content/uploads/2013/11/A-Elves-having-fun-Photo-by-Mark-Garvin.jpg In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I'm going through the days, solving both parts of each puzzle. Continuing on, today we
1
Add a comment...

Wayne Sheffield

Shared publicly  - 
 
In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 18. In this challenge, the fire department has cracked…
source: https://www.adafruit.com/images/145x109/2026-04.jpg In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I'm going through the days, solving both parts of each puzzle. Continuing on, today we have day 18. In this challenge, the fire department
1
Add a comment...
People
Have him in circles
138 people
William Bennett's profile photo
Karen Lopez's profile photo
Andie Letourneau's profile photo
Samuel David's profile photo
Michael Albert's profile photo
Alvin Ramard's profile photo
Kevin Kline's profile photo
Boris Hristov's profile photo
Rob Lepard's profile photo
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • WordPress
Story
Tagline
Microsoft Certified Master. Presenter on SQL Server. SQL Server development and administration since 6.5. Working in IT since 1991. Started programming computers in 1979.
Links