Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Friday Followup For July 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Which One’s Better?
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 66 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 July 2014

Friday Followup For July 18, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Which One’s Better?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 83 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 July 2014

Friday Followup For July 11, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Which One’s Better?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log Recovery Tool?
  • Cheating…

Read more

0 comments, 86 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 11 July 2014

Which One’s Better?

During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or some other variation. I promised a followup blog post to explore this and try to come up with a definitive answer. This is that post.

All of the examples… Read more

6 comments, 118 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 July 2014

Friday Followup For July 4, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Dell Webcast Followup: Subqueries For Superheroes
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter…

Read more

0 comments, 129 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 4 July 2014

Dell Webcast Followup: Subqueries For Superheroes

On June 24th, Dell Software gave me the privilege of presenting Subqueries For Superheroes as part of their Experts Perspective webcast series. This is one of my favorite presentations to give, and it’s always a treat to be invited to present for Dell.

In case you can’t tell from the… Read more

0 comments, 114 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 1 July 2014

Friday Followup For June 27, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Dell Webinar: Subqueries For Superheroes
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing

Read more

0 comments, 80 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 June 2014

Friday Followup For June 20, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC…

Read more

0 comments, 92 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 20 June 2014

Friday Followup For June 13, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Using A Non-correlated Subquery To Avoid DISTINCT
  • Do You Need A Log…

Read more

0 comments, 105 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 13 June 2014

Dell Webinar: Subqueries For Superheroes

For the second time this year, Dell Software has invited me to present as part of the webinar series on SQL Server. Have some free time on June 24th? Why not register and tune in? I’ll be presenting my Subqueries For Superheroes presentation.

Register here: https://software.dell.com/event/subqueries-for-superheroes866305

Disclaimer: There is nothing… Read more

0 comments, 131 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 9 June 2014

Friday Followup For June 6, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Do You Need A Log…

Read more

0 comments, 94 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 6 June 2014

Friday Followup For May 30, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Do You Need A Log Recovery Tool?
  • Building (for FREE) a Virtual…

Read more

0 comments, 116 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 May 2014

Friday Followup For May 23, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Do You Need A Log Recovery Tool?
  • Automated Permissions…

Read more

0 comments, 107 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 May 2014

Friday Followup For May 16, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log Recovery Tool?
  • Building (for FREE) a…

Read more

0 comments, 107 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 16 May 2014

Teamwork Keeps The Ship Afloat

I’m back from my

on the

with a big on

my face.

Like a good

I took lots (over 1400) pictures of

and

and

I also swam with a

Because I’m weird, and my brain is just programmed this way, whenever I’m in a busy place like an airport, a… Read more

0 comments, 146 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 15 May 2014

Friday Followup For May 9, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1

Read more

0 comments, 105 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 9 May 2014

Friday Followup For May 2, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Building (for FREE) a Virtual Server for SQL Demos
  • Don’t Get Slimed…

Read more

0 comments, 124 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 2 May 2014

Friday Followup For April 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC…

Read more

0 comments, 110 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 April 2014

Friday Followup For April 18, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Why So Serious? – #TSQL2sDAY #53
  • Do You Need A Log Recovery Tool?
  • Cheating DBCC To Fix Index…

Read more

0 comments, 133 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 April 2014

Friday Followup For April 11, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Why So Serious? – #TSQL2sDAY #53
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log…

Read more

0 comments, 109 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 11 April 2014

Older posts