Wayne Sheffield

My blog about SQL Server

ORM tools. They’re great. They’re evil. In the right hands, used the proper way, they can be a very powerful, very efficient, Rapid Application Development tool. It’s all about how the ORM tool is used – if it is abused or misunderstood, then very bad things will happen. The biggest problems with ORM tools are […]

Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from a table of sequential numbers. SQL Server 2012 introduces the LEAD function, which I’ve previously blogged about here. In that blog post, I covered how to do Gap Detection using the LEAD function. Now, it’s […]

This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he wants to know: “What do you think is a useful feature of SQL Server 2012?” Well, if you’ve been following my blog, then this should not be much of a surprise to you. My #1 […]

On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #111 in Alpharetta, GA (just north of Atlanta). Forget the tax man… come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and […]

SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of a date/time value. As I was experimenting with them, I was thinking that this is pretty neat, and bound to be very useful. And then I started wondering how well it performed. Before I had […]

This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized? On something? Or anything at all? Has that been a good or a bad thing? Why? I do specialize, in SQL Server, in development and administration areas. Why I decided to specialize My decision to […]

On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #110 in Tampa, FL. Come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, […]

Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result set that can be used in queries. You can select directly against them, or utilize them with the APPLY operator. These are truly versatile additions to SQL -and since you can pass parameters to them, […]

I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC on Saturday, November 5, 2011. The first session is in room 7091 at 1:15pm: “Table Vars and Temp Tables – What you NEED to know!” Come join me in this code filled session, where we’ll […]

On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #87 in Louisville, KY. Come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close