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

Archives: August 2010

Interview with SQL Server MVP Glenn Berry

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

0 comments, 1,019 reads

Posted in SQL Aloha on 31 August 2010

Project Phoenix: Late August Awards Announced

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

1 comments, 568 reads

Posted in SQLSequel on 31 August 2010

A PASSionate Community

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

0 comments, 560 reads

Posted in Joe Webb on 31 August 2010

SELECT, Deconstructed

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

10 comments, 1,075 reads

Posted in SQL Awesomesauce on 31 August 2010

Replication Gotcha - Including An Article In Multiple Publications

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

0 comments, 2,710 reads

Posted in Kendal Van Dyke on 31 August 2010

Unique and non-unique non-clustered indexes on a unique clustered index

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

1 comments, 5,520 reads

Posted in Klaus Aschenbrenner on 31 August 2010

SQLRally Pre-Con Selection Process – Draft for Comment

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

7 comments, 650 reads

Posted in SQLAndy on 31 August 2010

Return top 20 queries by Average CPU

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

3 comments, 1,896 reads

Posted in DatabaseExpertise.com on 31 August 2010

How to fix Orphaned Users

 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

2 comments, 887 reads

Posted in DatabaseExpertise.com on 31 August 2010

Determining the no of processor cores in your SQL Server

SELECT cpu_count/hyperthread_ratio AS cores
   FROM sys.dm_os_sys_info;

Read more

0 comments, 604 reads

Posted in DatabaseExpertise.com on 31 August 2010

Come and gone

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

0 comments, 535 reads

Posted in SQL In The Wild on 31 August 2010

Maintenance Plan "No description found" error

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

0 comments, 737 reads

Posted in Vinay Thakur on 31 August 2010

SQL Saturday #48 - Columbia - Call for Speakers Ending

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

Positioning SQLRally in the PASS Event Universe

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

0 comments, 779 reads

Posted in SQLAndy on 31 August 2010

Does Join Order Matter?

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

0 comments, 804 reads

Posted in The Voice of the DBA on 31 August 2010

How Old Are Your Database Statistics?

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

20 comments, 5,166 reads

Posted in Glenn Berry's SQL Server Performance on 30 August 2010

Defensive Db Programming Chapter 06

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

0 comments, 672 reads

Posted in SQL RNNR on 30 August 2010

Hardware Performance Research

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

0 comments, 813 reads

Posted in Glenn Berry's SQL Server Performance on 30 August 2010

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

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

#33-SSRS 2008 R2 - Indicators, Sparklines and Databars

Speaker: Patrick LeBlanc

Add To Outlook: Add To Calendar

Live Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=RZW5HJ&role=attend

Date and Time: 9/1/2010 11:30:00 AM CST
BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business…

Read more

0 comments, 565 reads

Posted in SQLDownSouth on 30 August 2010

Upcoming PASS Performance Virtual Chapter Presentation

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

0 comments, 550 reads

Posted in SQLAndy on 30 August 2010

Older posts