Pulse » Popular Items from 8/3/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
-
SQL SERVER – Computed Column – PERSISTED and Performance – Part 2
This is the third article in the series which I am writing on Persisted Columns. I suggest you read following two article first before continuing on this article. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and they take more ...
-
Order of Nested SCOPE Statements
Funny how you can work with a product for years and years and still discover new things, isn’t it? I was writing some scoped assignments on a cube the other day and found that when you’re using nested SCOPE statements, the order that you put those SCOPE statements ...
-
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would like to know some of the things that you do in order to get the much deserved R&R. Even if R&R means that you are changing jobs ...
-
Finger on the Pulse
We have made some changes at SQLServerPedia, the main one being the Pulse page. There is a HUGE and ever expanding amount of information available online around SQL Server these days and this can be an amazing resource for everyone working with the platform. The challenge can be finding your ...
-
Don’t Just Be Right, Make It Right
We wanted to bring our bikes on vacation this year, so that we could ride as a family along the Cape Cod Rail Trail. We needed a bike rack for the four bikes, but before that we needed to have a hitch put on our car. So we made an ...
-
Moving SharePoint to the data center
I cannot speak for the whole legal industry but where I work a lot of people love some SharePoint. It’s like 50 Cent says, “We love SharePoint like a fat kid loves cake.” And trust me we love some cake. With this mad love of SharePoint comes great collaboration ...
-
Presenting at SQL Connections in November
This will be my first trip to Las Vegas that isn't to catch a connection at McCarran, and it's also the first time I'll be going to SQL Connections. Several months ago, the call for abstracts went out, and Denny Cherry (blog|twitter) and I were the ...
-
Find tables with Large Obejct (LOB) data types in a database
From SQL Server 2005 onwards, the indexes can be re-indexed ONLINE. This ensures that the underlying tables and indexes are available for other users when the re-indexing is taking place. Also Standard and Workgroup editions of SQL The limitation for ONLINE Re-indexing is that it cannot be run on tables ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.