Wayne Sheffield

My blog about SQL Server

Browsing Posts in SQL

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may not have enough time to […]

A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement Table-Valued Functions (MSTVF). Since then, whenever I speak about ITVFs / MSTVFs, I’m frequently asked about how Scalar Functions (SF) perform. My stock answer has always been that they perform in a similar manner to […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may not have enough time to […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an […]

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev Nambi (blog | twitter) is hosting the party, and he has decided that the topic is to be on Assumptions. Specifically, he wants us to write about: A big assumption you encounter at work, one […]

You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means that the mirroring configuration includes having a witness server to ensure that the system can automatically switch over to the partner in the event of a failure of the principal. Under this scenario, if the […]

After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error occurred:  A required privilege is not held by the client.” when trying to start the service. Examining http://msdn.microsoft.com/en-us/library/ms175371.aspx shows that the only security privilege needed for the SSAS service account is the “Log on as […]

There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014 (6pm-8pm), and I’m honored to be presenting there for their kickoff meeting. I’ll be presenting “Table Vars & Temp Tables – What you NEED to Know!” Visit http://lynchburg.sqlpass.org/ for more info (abstract, directions) and to […]