This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with SQL Server MVP Glenn Berry (blog | Twitter).

 

Tell us a little about yourself Glenn.

After high school, I spent… Read more

Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will be reconsidered at each upcoming award cycle. (Refer to this to review the award criteria, details, and benefits.) In no order...(read more)

Read more

Much has voiced about the Professional Association for SQL Server (PASS) Nominating Committee’s decision to not put Steve Jones (blog, twitter) on the ballot for this year’s Board of Directors election. I’ve watched this controversy unfold with great interest, biting my tongue to keep from… Read more

Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing About SELECT blog.

We’re looking at the SELECT statement clauses in the order that the SQL engine logically processes them…we’ll even write it that way – it’ll look weird, but… Read more

When administering replication topologies it's common to group articles into publications based on roles that subscribers fulfill. Often you'll have multiple subscriber roles and therefore multiple publications, and in some cases a subset of articles are common between them. There's nothing to prevent you from adding the same article to… Read more

In the last weblog post I have talked about the difference of unique and non-unique clustered indexes. As you have seen SQL Server uses an internal overhead of 4 bytes (the so-called uniquifier) to make non-unique clustered index rows unique. Today I want to work out the difference between unique… Read more

Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando. It will be a two day conference, preceded by one day of seminars. Because it’s a new format, we can – if we choose – build a new process for… Read more

I’ve recently used this when troubleshooting some unexplained high CPU load on my server:

select top 20

st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,

CASE statement_end_offset

WHEN -1 THEN st.text

 ELSE

SUBSTRING(st.text,statement_start_offset/2,statement_end_offset/2)

END AS StatementText

from  sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st

ORDER BY AverageCPUTime DESC

Read more

 To view if there are any orphaned users, run this query against the DB;

 sp_change_users_login ‘report’

To fix;

 sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’

Read more

SELECT cpu_count/hyperthread_ratio AS cores

   FROM sys.dm_os_sys_info;

Read more

Or “Plan cache monitoring – insert and remove”

Previously I took a look at the CacheHit and CacheMiss events to see how they behave and how to identify what’s been searched for in the cache. in this follow up, I want to take a similar look at the… Read more

for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description found” and you cannot edit the Maitainance plan. problem could be the software you install is confilicting with sql server … Continue reading →

Read more

This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers for SQL Saturday #48 - Columbia will be ending in 2 days, on September 2, 2010. We're hoping to publish the schedule by Monday, September 6, 2010, to give all… Read more

Prior to creating SQLRally the world of PASS consisted of the PASS Summit which is our annual mega-event, the European Summit, SQLSaturday, chapter meetings, and the occasional launch event. With all that going on, did we need another brand? What market void does it fill? And how is it… Read more

According to Conor Cunningham, it doesn’t.

I have heard that there are issues in the optimizer, and to be sure, there are cases where the order can matter, but for most normal queries, most inner joins, order doesn’t matter. As Conor says, it might seem that a change produces… Read more

Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having issues with poor query performance on a SQL Server 2005 instance on very good hardware. After having them run my standard SQL Server 2005 Diagnostic Information queries, nothing glaringly obvious… Read more

We are here again after another week and ready for another episode in this series.  Today we get to talk about chapter 6 in the book by Alex Kuznetsov (Blog).  You can find more on this series by looking here.

Common Problems with Data Integrity

Alex explains… Read more

I am trying to gather some information about some of the newer Intel and AMD processors as part of my research for some upcoming presentations.  I am looking at the possible correlation between TPC-E scores and Geekbench scores. Matching TPC-E scores to Geekbench scores, I see some indications of a…

Read more

Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)

Read more

I’ll be doing an introductory level presentation on statistics for the Performance VC on September 7th, details and the LiveMeeting URL at http://performance.sqlpass.org/). For those of you who have been tuning for a while you’re not likely to learn a lot of new stuff, really focused on those new… Read more