Pulse » Popular Items from 8/31/2010
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
August
-
Database Schema Tracking
I am not sure why I have never done this before. I can think of many reasons why one would want to track the changes that are being made to their databases. There are the obvious reasons to do this: Auditing (Make sure the changes that were supposed to happen ...
-
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 making rash ...
-
Hartford SQL Server User Group Meeting Tomorrow
Sorry for the late post on this, but better late than never, right? Tomorrow at noon (ET) will be the second meeting for the Hartford SQL Server User Group (HSSUG). That’s right, we meet during the day because we prefer to be home at night instead of, well, at ...
-
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 ...
-
5 things I want to change while on the PASS Board
I've been doing a lot of thinking over the last 3 or 4 months about «why» I wanted to run for the PASS Board. I think I have finally come to the point where I can distill it down into a list of 5 specific things that I will ...
-
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 ...
-
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 ...
-
Change ‘Edit Top 200 rows’ setting in SSMS 2008
SQL Server Management Studio (SSMS) is a good feature rich tool. While many choose to do data manipulation using T-SQL queries, there are a lot of users who make use of SSMS for manipulating data. Until SQL Server 2008, right clicking on the table would provide options to SELECT or ...
-
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 CacheInsert and ...
-
They See Things Differently
Every once in a while, I’ll be talking with a friend about presentations and they mention that they really like the visual flow or the artwork or something about the presentation. After I get over being flattered (trust me, it’s easy to do), we’ll start talking about ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.